>> [...]. Currently, in MySQL
>> you must call UNLOCK TABLES before issuing another LOCK TABLES, because
>> there is no deadlock detection in MySQL itself.
>I believe a LOCK TABLES does an automatic atomic UNLOCK TABLES of any
>that were locked before if it's able to get the requested locks.
>Tim.
Right, sorry, I was thinking the internal workings of the database.
By the way, has anyone felt a need for 'gradual' table locking:
i.e., if you do not know in advance which tables you should lock,
and only find out during the transaction? Then you might want to
set more table locks during the transaction. I guess such a need for
gradual table locking is not very common?
Regards,
Heikki
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
