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,
-- Marcin Lewandowski [ mailto:[EMAIL PROTECTED] gg:188068 jid:[EMAIL PROTECTED] ] [ http://www.nosoftwarepatents.com/pl/m/intro/index.html ]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]