[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;
WHERE expects an integer (and will convert other types to an integer). 0 is false, null is null, everything else is true. Hence, "WHERE invoiceid-12217" is true for every row where invoiceid is neither 12217 nor null. I expect you changed every row except the one you wanted.
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??
Restore from backup.
Thanks.
Michael
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
