On Mon, 1999-10-04 17:26:05 -0100, Thomas Lund wrote:
> When creating a table with not null in an auto_increment field,
> mysql ignores the not null
No, but you might have got confused about the output of SHOW FIELDS?
The 'Null' column is empty, meaning NOT NULL.
Only the 'Default' is set to NULL, which indicates that you are
allowed to store a NULL into this column (which actually doesn't store
a NULL value, but the next available one).
We had the same question recently, so if you want to read the old
thread e-mail mysql-thread13839@stripped, or see
<URL: http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:sss:13839 >
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=5244 5EF3 B0B1 3826 E4EC 8058 7B31 3AD7