List:General Discussion« Previous MessageNext Message »
From:<nngau Date:May 17 2005 4:32pm
Subject:RE: why does this query work??!!! - THANKS!!!
View as plain text  
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:peter.brawley@stripped] 
Sent: Tuesday, May 17, 2005 10:17 AM
Cc: mysql@stripped
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

-----

nngau@stripped 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/mysql?unsub=1

Thread
re: using OR seems faster than using INJames Black17 May
  • why does this query work??!!!nngau17 May
    • Re: why does this query work??!!!mfatene17 May
    • Re: why does this query work??!!!Michael Stassen17 May
    • Re: why does this query work??!!!Peter Brawley17 May
      • RE: why does this query work??!!! - THANKS!!!nngau17 May