Hello.
As for me, SELECT ... FOR UPDATE could help in your situation. See: http://dev.mysql.com/doc/mysql/en/innodb-locking-reads.html Locking the whole InnoDB table is usually not a very good solution, because it does row-level locking. Marcin Lewandowski <[EMAIL PROTECTED]> wrote: > Hi, > > I want to use InnoDB tables in my project, because I can use > transactions with them. > > I would write a hotel room's reservation system and sometimes I would > need to get from particular SELECT query exact state - whether room is > reserved or not. Because, when I'm using innodb I work only on copy of > database, is it possible to check if any other connection is not writing > to particular table? Would locking tables help? Or maybe I should do > something else then locking table when writing reservation? > > 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]
