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 [EMAIL PROTECTED]: > 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/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
