Skip navigation links

MySQL Forums :: InnoDB :: COMMIT function take too much time to respond


Advanced Search

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
COMMIT function take too much time to respond 1744 He Ha 04/09/2011 02:35AM
Re: COMMIT function take too much time to respond 547 Rick James 04/10/2011 04:11PM
Re: COMMIT function take too much time to respond 492 He Ha 04/10/2011 08:09PM
Re: COMMIT function take too much time to respond 487 Rick James 04/10/2011 10:15PM
Re: COMMIT function take too much time to respond 773 He Ha 04/10/2011 10:23PM
Re: COMMIT function take too much time to respond 556 Rick James 04/11/2011 09:41PM


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.