1INSERT INTO table_name (column_list)
2VALUES
3 (value_list_1),
4 (value_list_2),
5 ...
6 (value_list_n);
7
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;