From: Martijn Tonies
Date: November 1 2003 2:02pm
Subject: Re: "not null" and default values confusion
List-Archive: http://lists.mysql.com/mysql/152874
Message-Id: <000b01c3a080$c2732550$0a02a8c0@seal>
MIME-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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