Jump to content


Photo

Undoing Update


  • Please log in to reply
1 reply to this topic

#1 mysql_novice

mysql_novice
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 01 February 2003 - 05:05 PM

I accidentally updated all of the entries in one column in a table. I missed out on using a WHERE clause and so, instead of only the offending entry being updated, all the entries got updated... I was in autocommit mode when this happened... So, I gather I can\'t use rollback... Is there anyway I could undo this disaster.... Any insights????

#2 metalblend

metalblend
  • Members
  • PipPipPip
  • Advanced Member
  • 89 posts
  • LocationCalifornia, USA

Posted 02 February 2003 - 12:46 AM

..I\'m not sure what you can do to fix it.
I just have to say, \"Wow.. that\'s horrible.\"

Sorry..




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users