mysql query browser: is it possible to undo change?
I have updated a table in a databa开发者_如何学Gose using mysql query browser. is it possible to roll back?
Try using the rollback button on the Mysql Query Browser toobar. If it doesn't work, the change has already been committed and cannot be undone anymore. Try retrieving things from a backup instead.
'Fraid not. If you don't have a backup and the update was not run inside an as yet uncommitted transaction then there isn't much you can do. Using the safe-updates option can help prevent some kinds of mistakes, generally those where the where clause has been forgotten however again is no help retrospectively. Sorry!
精彩评论