> 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,
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.