List:General Discussion« Previous MessageNext Message »
From:mfatene Date:May 17 2005 4:05pm
Subject:Re: why does this query work??!!!
View as plain text  
Hi,
your query updates all the records where invoiceid != 12217
That's the same than :

update customer_order_history set customerID="123 456 789 0123" where
invoiceid != 12217;
because  invoiceid-12217 !=0. It's so true.

have you a backup if the command is old (no flashback query in mysql) ?

Mathias

Selon nngau@stripped:

> 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.
>
>
> --
> 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