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" <[EMAIL PROTECTED]> Visit my web laboratory at http://beta.unclassified.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]