mysql rollback on myisam engine

Question

by mistake

i run the update query ,

This update made my table all rows values as o ,

Is it possible to rollback the table values ,

Plz advise

Answer 1

If you have no backup, and didn't run your update in a transaction, your data is gone for good.

Answer 2

http://stackoverflow.com/questions/2950676/difference-between-set-autocommit1-and-start-transaction-in-mysql-have-i-missed