CODEWITHSUNDEEP
mysql
Onic Team
Onic Team

Reputation: 1658

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.

Upvotes: 1

Views: 3502

Answers (1)

Golu Sharma
Golu Sharma

Reputation: 70

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

Upvotes: 2

Related Questions