how to copy a table from one database to another in mysql
INSERT INTO database2.table2 SELECT * from database1.table1
Source: stackoverflow.com
mysql copy data from one table to another
UPDATE `Table2` JOIN `Table1` ON `Table1`.`a_id` = `Table2`.`id` SET `Table2`.`txn_stamp` = `Table1`.`tranx_id`