Help me to understand multiple locking the same tables (lock; lock; unlock)

2007-01-10 Thread Denis Solovyov
Dear friends, Please help me to understand several LOCKing the same tables without unlocking them between LOCKs. Imagine the following code: LOCK TABLES t1 READ, t2 READ; -- some hard select queries which need that other threads do not update tables LOCK TABLES t1 WRITE, t2 WRITE; --

RE: Help me to understand multiple locking the same tables (lock; lock; unlock)

2007-01-10 Thread Jerry Schwartz
:[EMAIL PROTECTED] Sent: Wednesday, January 10, 2007 2:29 PM To: mysql@lists.mysql.com Subject: Help me to understand multiple locking the same tables (lock; lock; unlock) Dear friends, Please help me to understand several LOCKing the same tables without unlocking them between LOCKs