insert query

Question

how to insert data in a table

Pankaj Kumar Choudhary · Answer

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');

Khan Abrar Ahmed · Answer

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

Rajeesh Menoth · Answer

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: INSERT INTO table_name ( column1 , column2 , column3 ,...) VALUES ( value1 , value2 , value3 ,...); More ref : http://www.w3schools.com/sql/sql_insert.asp

insert query

Answers (3)