MySQL: Insert from Select

INSERT INTO table1 (column1)
	SELECT col1
	FROM table2;

INSERT INTO table1 (column1, column2, column3)
	SELECT col1, col2, col3
	FROM table2;

 

Related Snippets

•	MySQL: Update using a Left Join