1INSERT INTO table
2(column1, column2, ... column_n )
3VALUES
4(expression1, expression2, ... expression_n );
1INSERT INTO table_name (a, b) VALUES (val1, val2);
2INSERT INTO table_name (a, b) VALUES (val1, val2), (val3, val4); -- 2 rows
3
4-- From a query:
5INSERT INTO table_name (a, b)
6 SELECT val1 AS a, val2 AS b
7 FROM source_table s
8 WHERE s.val1 >= 10;
1INSERT INTO my_table SELECT * FROM source_table;
2INSERT INTO my_table (a, b, c) SELECT a, b, c FROM source_table;
3INSERT INTO my_table (a, b, c) SELECT a, b, c FROM source_table s
4 WHERE s.my_col >= 10;
1INSERT INTO table
2(column1, column2, ... column_n )
3SELECT expression1, expression2, ... expression_n
4FROM source_table
5[WHERE conditions];