1 INSERT INTO table2
2 (name, email, phone)
3 SELECT name, email, phone
4 FROM table1;
5
1INSERT INTO my_table SELECT * FROM source_table;
2INSERT INTO my_table (a, b, c) SELECT a, b, c FROM source_table;
3INSERT INTO my_table (a, b, c) SELECT a, b, c FROM source_table s
4 WHERE s.my_col >= 10;