mysql update 如何回滚？

Question

昨天晚上手贱update一张表，忘加限制条件了,本来应该是
update companys set right=1 where id =1234

后面的where id=1234忘加了，结果所有数据都update了。欲哭无泪。
请问怎么回滚呢？
求大神救急

Answer 1

It’s already too late, because only transactions can assist in completing the rollback, and what you have already completed cannot be rolled back! Unless you have done a database backup~

Answer 2

Have you turned on the binary log? You should be able to restore it to before the update

Answer 3

Have you opened the bin-log in your database? If so, open the statement where you were found and restore the replay of the bin-log of the misoperation statement.

Answer 4

You can use binlog2sql to quickly roll back. For specific methods, please see this article "How to quickly recover data after MySQL misoperation"