insert mysql

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 table1 (col1, col2) VALUES (3, 'A string');
2INSERT INTO table1 (col1) VALUES (3);			-- col2 will be NULL if allowed
3INSERT INTO table1 VALUES (3, 'A string');     	-- all table1 columns
4INSERT INTO table1 (col1, col2) SELECT value3, value1 FROM table2;

1INSERT INTO tbl_name (a,b,c) 
2    VALUES(1,2,3), (4,5,6), (7,8,9);

1INSERT INTO "table_name" ("column1", "column2", "column3", ...)
2VALUES ('value1', "value2", 'value3', ...);