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 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,
use
SELECT ... LOCKIN SHARE MODE
or
SELECT ... FOR UPDATE
-- Marcin Lewandowski [ mailto:[EMAIL PROTECTED] gg:188068 jid:[EMAIL PROTECTED] ] [ http://www.nosoftwarepatents.com/pl/m/intro/index.html ]
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php
Order MySQL Network from http://www.mysql.com/network/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
