INSERT INTO table2 SELECT * FROM table1;
INSERT INTO table2 (column_name(s)) SELECT column_name(s) FROM table1;
INSERT INTO table1 (col1, col2) SELECT col3, col4 FROM table2 WHERE id = 1;
INSERT INTO table2 SELECT * FROM table1;
INSERT INTO table2 (column_name(s)) SELECT column_name(s) FROM table1;
INSERT INTO table1 (col1, col2) SELECT col3, col4 FROM table2 WHERE id = 1;