取决于您的表的大小以及您是否要对从 table1 移动到 table2 的内容进行选择性:

Depending on the size of your tables and whether or not you want to be selective about what you move from table1 to table2:

INSERT INTO table2 (field1,field2,field3)
SELECT field1,field2,field3 FROM table1

应该要诀窍，根据需要添加命令和 where 子句等！

Should to the trick, add orders and where clauses etc as required!