Difference between revisions of "MariaDB/SQL/INSERT"
Jump to navigation
Jump to search
(Created page with "{{fmt/title|"INSERT" SQL statement|see also: in MySQL}} ==Examples== Note: "<code>INSERT</code>" implies "<code>INSERT INTO</code>"; the "<code>INTO</code>" i...") |
(No difference)
|
Latest revision as of 21:40, 18 February 2025
|
"INSERT" SQL statement see also: in MySQL
|
Examples
Note: "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...