Use one query to copy data from tb1 to tb2

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