On 20.12.2007 20:34 CE(S)T, Martijn Tonies wrote: > Are your tables InnoDB? If so, the snapshot transaction is giving you > a static view on the data and your own changes, while your PHPMyAdmin > commits the NULL write. Your application keeps on seeing your own > changes, cause it did not end the snapshot transaction.
Yes, all tables are InnoDB. So MySQL does support nested transaction and both "SET AUTOCOMMIT = 0" and "START TRANSACTION" start a new transaction level, is that true? -- 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]