I'll try posting this again, because nobody has replied to it.
To put the problem more succinctly: I think there is a flaw in the mysql
LOCK statement semantics, because if I use LOCK then all tables that are
accessed while the LOCK is active must be locked for READ or WRITE
access (or insert,
Raju
-Original Message-
From: Bob Sidebotham [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 07, 2002 2:00 PM
To: [EMAIL PROTECTED]
Subject: Re: LOCK TABLES issue
I'll try posting this again, because nobody has replied to it.
To put the problem more succinctly: I think there is a flaw
I have an application with fairly typical locking requirements: 99% of
the requests are read-only (with an exception that I will specify).
Update requests are relatively rare. There's a half-dozen tables, and
since the inter-relationships are a little complex. I found it easiest,
given the