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
