> What error occurs if i try to access (read or write) a table that was
locked
> (LOCK TABLES mytable WRITE) by another thread?
My belief is that you do not get an error. The thread attempting to access
the
locked table is stalled until the lock is released. If the lock is never
released, you may eventually get a timeout.
It would not be a good thing if one database user could create unexpected
errors for another by use of locking.
Alec Cawley
Mysql query
---------------------------------------------------------------------
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
