Yves Goergen wrote:
> On 13.11.2007 14:01 CE(S)T, Baron Schwartz wrote:
>> It's more complicated than that. You can use them together, you just
>> have to do it like this:
>> set autocommit = 0;
>> lock tables;
>> -- you are now in a transaction automatically begun by LOCK TABLES
> I assume that at this point, any SELECT on the table I have locked
> should block. But guess what, it doesn't. So it doesn't really lock.
What kind of lock are you using?
-- cxn 1
lock tables t1 write;
Query OK, 0 rows affected (6.29 sec)
-- cxn 2
select * from t1;