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;
> begin;
> 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.
> commit;
> -- your tables are now unlocked.
>
> In fact, you *must* use a transaction for LOCK TABLES to be safe, at
> least in MySQL 5. Even if you're using non-transactional tables.
> Otherwise, you can get nasty behavior. See
> http://bugs.mysql.com/bug.php?id=31479
--
Yves Goergen "LonelyPixel" <nospam.list@stripped>
Visit my web laboratory at http://beta.unclassified.de
