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