From: Denis Solovyov [mailto:[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 LOCKi
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;
-- so
