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 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 same query or even I updated the record (which
is locked by the other computer), but I didn't get any error. How does this
work? Did I miss anything here?
My other question: if I lock a record with that command, then how I can
release the lock? I could find any command to release the lock!
thanks
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]