On 20.12.2007 21:34 CE(S)T, Martijn Tonies wrote: >> So MySQL does support nested transaction and both "SET AUTOCOMMIT = 0" >> and "START TRANSACTION" start a new transaction level, is that true? > > I didn't say it supports nested transactions, I said that if your > application > starts a single transaction and does not finish it, it will continue seeing > the same data despite other transactions (PHPMyAdmin) changing your > data.
Okay, I got that. So a COMMIT statement after disabling autocommit mode and another START TRANSACTION does not finish my transaction. (But then, what does?) Interesting view, I didn't know that. But now all's clear: I won't touch autocommit mode anymore and everything works as expected. Thanks for your help. -- 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]