I am working on a sql query where i need to dump older than 3 years record from one table to other archive table

I have two sql table test and test_archives both table column is same.

My test table containing 1,000,000 record. I want to move record to test_archives from test those are older than 3 years.

Thanks

from Recent Questions - Stack Overflow https://ift.tt/344wcJA
https://ift.tt/eA8V8J