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 1785 He Ha 04/09/2011 02:35AM
Re: COMMIT function take too much time to respond 577 Rick James 04/10/2011 04:11PM
Re: COMMIT function take too much time to respond 519 He Ha 04/10/2011 08:09PM
Re: COMMIT function take too much time to respond 498 Rick James 04/10/2011 10:15PM
Re: COMMIT function take too much time to respond 803 He Ha 04/10/2011 10:23PM
Re: COMMIT function take too much time to respond 595 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.