Re: Not locking....

[Lalit Shakya]

I think this may help you. Better is that write this code in function or procedure
if your AUTOCOMMIT=1; then it


SET AUTOCOMMIT=0;

LOCK TABLES table name WRITE (or Read if your required only select)
Start transaction
begin
SELECT * FROM `data` WHERE `page` = 'menu' LIMIT 3 LOCK IN share mode;
end
UNLOCK TABLES;
commit