更新时间:2023-02-03 18:07:56
INSERT INTO archive_table
SELECT * FROM original_table WHERE id = 1
很简单。
表格具有不同的列号,其他布局等,您必须指定列:
If tables have different column number, other layout etc., you will have to specify columns :too
INSERT INTO archive_table(field1, field2, field3)
SELECT field7, field8, field9 FROM original_table WHERE id = 1