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]
