Re: table locking

[Rick James]

FOR UPDATE needs to be inside a transaction for it to block other updates.

Plan A:

BEGIN;
SELECT ... FOR UPDATE;
...
COMMIT;

PLAN B:

SET @@autocommit=0;
SELECT ... FOR UPDATE;
...
COMMIT;