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