Woozle at 21:43, 18 February 2025

2025-02-18T21:43:00Z

← Older revision		Revision as of 21:43, 18 February 2025
Line 1:		Line 1:
	==~~Usage~~==		{{fmt/title\|"INSERT" SQL statement\|see also: [[MariaDB/SQL/INSERT\|in MariaDB]]}}
	"INSERT" implies "INSERT INTO"; the "INTO" is always optional.		==Examples==
	Inserting a list of values:~~<source lang=mysql>~~INSERT table_name(col1,col2,col3...) VALUES (value1, value2, value3...)~~</source>~~		Note: "<code>INSERT</code>" implies "<code>INSERT INTO</code>"; the "<code>INTO</code>" is always optional.
	Inserting the contents of another table or query (NOT YET VERIFIED):~~<source lang=mysql>~~INSERT table_name(col1,col2,col3...) SELECT col1,col2,col3 FROM...~~</source>~~		* Inserting a list of values:{{fmt/syntax/block\|SQL\|INSERT table_name(col1,col2,col3...) VALUES (value1, value2, value3...)}}
			* Inserting the contents of another table or query (NOT YET VERIFIED):{{fmt/syntax/block\|SQL\|INSERT table_name(col1,col2,col3...) SELECT col1,col2,col3 FROM...}}
	==Links==		==Links==
	* [https://dev.mysql.com/doc/refman/8.0/en/insert.html MySQL 8.0 Reference Manual]		* [https://dev.mysql.com/doc/refman/8.0/en/insert.html MySQL 8.0 Reference Manual]

Woozle: Created page with "==Usage== "INSERT" implies "INSERT INTO"; the "INTO" is always optional. Inserting a list of values:INSERT table_name(col1,col2,col3...) VALUES (value1, val..."

2019-10-26T01:06:34Z

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..."

New page

==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, value2, value3...)</source>
Inserting the contents of another table or query (NOT YET VERIFIED):<source lang=mysql>INSERT table_name(col1,col2,col3...) SELECT col1,col2,col3 FROM...</source>
==Links==
* [https://dev.mysql.com/doc/refman/8.0/en/insert.html MySQL 8.0 Reference Manual]

MySQL/INSERT - Revision history

Woozle at 21:43, 18 February 2025

Woozle: Created page with "==Usage== "INSERT" implies "INSERT INTO"; the "INTO" is always optional. Inserting a list of values:INSERT table_name(col1,col2,col3...) VALUES (value1, val..."