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;