Thanks everyone!! It was just a typo and everything was updated :( That's okay, I got my Admin guy to restore backup files. I'll just Have to get in the habit of using commit and rollback.
-----Original Message----- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 17, 2005 10:17 AM Cc: mysql@lists.mysql.com Subject: Re: why does this query work??!!! NNGau, It works because 'where invoiceid-12217' is true for every invoice except invoice 12217. To undo it, assuming your server is running a binary log, back up the table in its current state to a safe place, restore the most recent backup of the table, then run mysqlbinlog for that database (-d) and that table (-t) from the timepoint of the backup (-start-datetime=...) to just before your typo (-stop-datetime=...). PB ----- [EMAIL PROTECTED] wrote: >Help! I did this query and it updated everything! > >update customer_order_history set customerID="123 456 789 0123" where >invoiceid-12217; > > >I typed a '-' rather than an '='. > >I haven't did a commit or a rollback saving point. Is there any other >way To undo this update?? > > > >Thanks. > > > > -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.12 - Release Date: 5/17/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]