Use one query to copy data from tb1 to tb2
Posted on
Example intro
Copy data from tb1 to tb2
INSERT INTO tb2 SELECT * FROM tb1
Copy specific columns from tb1 to tb2
INSERT INTO tb2 (col1,col2) SELECT col11,col12 FROM tb1
Copy specific columns from tb1 to tb2 with WHERE statement
INSERT INTO tb2 (col1,col2) SELECT col11,col12 FROM tb1 WHERE col11 > 1