Hi, > This question comes up a lot. You should take a look at > <http://www.mysql.com/doc/en/constraint_NOT_NULL.html>. The first line > is, "To be able to support easy handling of non-transactional tables, > all fields in MySQL have default values." Mysql automatically converts > missing or illegal values to column defaults, because in the > non-transactional case, it cannot roll back when you have an illegal > value in the Nth row of a multi row insert.
Question: why a "rollback" - it should allow the insert in the first place, right? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
