Loading

how can i do that?

Gopal

i need some help writing a stored procedure to archive old rows (delete and insert to archive tables)
i want to run a select that will return users ids that were deleted the past 24 hours, and then archive all their rows from tables according to this id.
how can i do that?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Vishal Joshi4y ago
You can use UNIX_TIMESTAMP to get the last 24 hours record.
SELECT Id
from SourceTable
where your_column >= UNIX_TIMESTAMP(date_sub(now(),interval 24 hour));
Then you can use a query to insert data to the archive table and delete it from source as below:
INSERT INTO ArchiveTable (column1, column2, column3, ...)
SELECT column1, column2, column3, ...
FROM SourceTable
WHERE Id in (ids);


DELETE FROM SourceTable WHERE Id in (ids);
0