Hello.
Use:
set autocommit=0;
or begin a transaction before executing 'select ... lock in share mode'.
Commit the tramsaction to release lock.
"Mojtaba Faridzad" <[EMAIL PROTECTED]> wrote:
> Hi,
> I am trying to learn more about InnoDB to convert MyISAM to InnoDB.
> according to MyS
Hi,
I am trying to learn more about InnoDB to convert MyISAM to InnoDB.
according to MySQL document, I can lock a record like this:
SELECT * FROM mytable WHERE id = '100' LOCK IN SHARE MODE;
I run this query and showed a message to stop the screen (waiting) and on
the other computer I run the sa