How can I move data from my current table to an archive table when a delete is called on the table?
My current table and archive table needs to be in sync in their schema too.
Can someone help me?
I am using MySql
(This answer is assuming SQL Server)
This would result in an audit table of a copy of the deleted records. I would recommend putting a