Difference between revisions of "MySQL/INSERT"
< MySQL
Jump to navigation
Jump to search
(Created page with "==Usage== "INSERT" implies "INSERT INTO"; the "INTO" is always optional. Inserting a list of values:<source lang=mysql>INSERT table_name(col1,col2,col3...) VALUES (value1, val...") |
(No difference)
|
Latest revision as of 01:06, 26 October 2019
Usage
"INSERT" implies "INSERT INTO"; the "INTO" is always optional.
Inserting a list of values:
INSERT table_name(col1,col2,col3...) VALUES (value1, value2, value3...)
Inserting the contents of another table or query (NOT YET VERIFIED):
INSERT table_name(col1,col2,col3...) SELECT col1,col2,col3 FROM...