MySQL Forums
Forum List  »  InnoDB

Re: COMMIT function take too much time to respond
Posted by: He Ha
Date: April 10, 2011 10:23PM

It's

UPDATE `gc_monster` SET `loyalty` = CASE `id` WHEN '11' THEN 100 WHEN '12' THEN 100 WHEN '13' THEN 100 ELSE `loyalty` END WHERE `id` IN (11, 12, 13) LIMIT 3

It do not like this exactly but that query in image has just more field to update.



Edited 1 time(s). Last edit at 04/10/2011 10:24PM by He Ha.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: COMMIT function take too much time to respond
965
April 10, 2011 10:23PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.