* Mark Rages > According to the docs, single update statements are atomic.
I would not say that your problem is with atomicity, but with consistency. It is expected that a transaction oriented database should follow the ACID properties, and with them, any consistency properties should not be evaluated until the transaction is committed. Appearantly MySQL is not able to do so. (Which is perhaps a trade off between speed and functionality.) Why don't you just drop the unique criterium and do the consistency check by youself? -- Jon Haugsand, [EMAIL PROTECTED] http://www.norges-bank.no -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]