insert | SoloLearn: Learn to code for FREE!

+1

insert

select

sql

2/6/2017 3:09:24 AM

joker

2 Answers

New Answer

+24

into table values(............)

0

The INSERT INTO statement is used to insert new records in a table. Syntax INSERT INTO table_name VALUES (value1,value2,value3,...); INSERT INTO table_name (column1,column2,column3,...) VALUES (value1,value2,value3,...); Eg INSERT INTO Customers VALUES ('Cardinal','Tom B. Erichsen','Skagen 21','Stavanger','4006','Norway'); INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country) VALUES ('Cardinal','Tom B. Erichsen','Skagen 21','Stavanger','4006','Norway');