user872258 user872258 - 3 months ago 16
MySQL Question

MYSQL DELETE and Roll back

I have a problem.

Past month I have a user query:

DELETE
FROM table_name
WHERE name = 'test';


it deletes approx 100 rows which is working fine.

But now I need that the delete rows that were deleted are rolled back? Is there is any procedure to get all my rows back?

I am using mysql.

Thanks in advance

Answer

No. The rows are gone. MySQL has no built-in revision control constructs. If you are worried about this being a common occurrence, make sure to back up your database before you run these kinds of queries (look into mysqldump)