insert query

Hello @Deepika

 

insert into "tablename"
 (first_column,...last_column)
  values (first_value,...last_value);

In the example below, the column name first will match up with the value 'Luke', and the column name state will match up with the value 'Georgia'.

Example:

insert into employee
  (first, last, age, address, city, state)
  values ('Luke', 'Duke', 45, '2130 Boars Nest', 
          'Hazard Co', 'Georgia');

INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
 VALUES ('Cardinal','Tom B. Erichsen','Skagen 21','Stavanger','4006','Norway'); 

Hi follow this sites.

 

http://www.w3schools.com/sql/sql_insert.asp

https://technet.microsoft.com/en-us/library/dd776381%28v=sql.105%29.aspx

https://msdn.microsoft.com/en-us/library/ms174335.aspx 

Hi

 

The first form does not specify the column names where the data will be inserted, only their values: 

 

INSERT INTO table_name
VALUES (value1,value2,value3,...); 

 

The second form specifies both the column names and the values to be inserted: 

 

 

More ref : http://www.w3schools.com/sql/sql_insert.asp