Pasar data de una tabla a otra

Para insertar data de una tabla a otra

INSERT INTO statement:

INSERT INTO TABLE2 SELECT * FROM TABLE1
INSERT INTO TABLE2 SELECT * FROM TABLE1 WHERE COL1 = 'A'
INSERT INTO TABLE2 (COL1, COL2, COL3) SELECT COL1, COL4, COL7 FROM TABLE1