LOCK TABLES table1 WRITE, table2 WRITE

INSERT INTO table1 SELECT * FROM table2;

UNLOCK TABLES