Skip to content

INSERT INTO ​

The INSERT INTO syntax appends data to a table.

Syntax ​

bash
INSERT INTO TABLE <table>
{ 
	SELECT select_statement  
	| VALUES (value [, value ...]) [, (value [, value ...]) ...]
}

<table> ​

Table you want insert lines into.

select_statement ​

Your chosen select statement.

VALUES Clause ​

The VALUES clause lets you insert one or more rows by specifying constant values for all the columns. Be aware that the number, types, and order of expression must match the table definition.

Output ​

This SQL command does not return anything.