INSERT INTO

Use this statement to insert data into an existing table. Its syntax is:

 INSERT INTO table [(fieldlist)] VALUES (valuelist)

 INSERT INTO table [(fieldlist)] selectstatement

The parts of this statement have the following meaning:

Part Meaning

table The table into which the data is to be inserted

fieldlist Ordered list of data fields

valuelist A list of values which are inserted into the corresponding fields

selectstatement Any SELECT statement returning data rows compatible with the fieldlist

[Return to SQL Syntax]

Part	Meaning
table	The table into which the data is to be inserted
fieldlist	Ordered list of data fields
valuelist	A list of values which are inserted into the corresponding fields
selectstatement	Any SELECT statement returning data rows compatible with the fieldlist