I know there is table locking for MySQL It works in your MySQL database.
lock tables temp write;
But it is too costly in my case. I would prefer row locking. I successfully created a table with ENGINE=InnoDB, however, when I tried row locking by using:
SELECT ... LOCK IN SHARE MODE;
SELECT ... FOR UPDATE;
They both error out.
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 30' at line 2
Do you know how I can do row locking in MySQL?