MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Tricky problem with parallel update of table.
Posted by: Rick James
Date: May 22, 2013 09:59PM

BEGIN;
do all the steps
COMMIT;

And check for errors after each query. If you get a deadlock, start over at the BEGIN.

Read about "transactions" and "ACID".

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Tricky problem with parallel update of table.
1245
James La Guma
May 22, 2013 12:12AM
Re: Tricky problem with parallel update of table.
610
Rick James
May 22, 2013 09:59PM


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.