-1

By mistake I have update a table without condition.

Is there any way to restore that table in MySQL?

vhu
  • 12,244
  • 11
  • 38
  • 48
Learner
  • 347
  • 1
  • 5
  • 11
  • If transaction was commited (I assume it was since it's autocommit by default) you are pretty much done. – cen Jul 14 '15 at 07:33

1 Answers1

1

You can try using ROLLBACK command.
But as mentioned in the comments, if the transaction was committed, maybe you should start searching for the script that created the table.

pri
  • 1,521
  • 2
  • 13
  • 26