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
Marcin,
- Original Message -
From: "Marcin Lewandowski" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Sunday, May 01, 2005 7:25 PM
Subject: Synchronizing InnoDB tables
Hi,
I want to use InnoDB tables in my project, because I can use
transactions with the
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 co
