Ved Prakash Ved Prakash - 3 years ago 93
MySQL Question

How to rollback MySQL table after update Statement

By mistake, I executed MySQL command in command line without where condition.

update actor set first_name = 'Ved' , last_name ='Prakash';

it updated my all 500 rows with same first_name and last_name. any possibility to restore or rollback. I don't have the backup.

Answer Source

when you start to writing sql command in MySQL.

Remember autocommit =0 then you use rollback otherwise not possible.

Hope this help you for next MySQL command

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