user872258 user872258 - 1 year ago 86
MySQL Question

MYSQL DELETE and Roll back

I have a problem.

Past month I have a user query:

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 Source

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)

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download