mysql撈取後塞入指定表格

INSERT INTO target_table_archive (col1, col2, …, coln)
SELECT col1, col2, …, coln
FROM this_table
WHERE thedate < '2016-01-01 00:00:00';