[ic] autonumber with mySQL

[Jon Jensen]

On Wed, 14 Jan 2004, Grant wrote:

> > Do I have another shot in the dark <g> ? I think you missing NOT NULL for
> > the code column.
> 
> Thank you very much for your help Racke and Rene.  The NOT NULL was missing.

I don't see how that can be the case. The MySQL documentation says (and a
quick test creating a table in MySQL verifies):

> A PRIMARY KEY is a unique KEY where all key columns must be defined as NOT 
> NULL. If they are not explicitly declared as NOT NULL, it will be done 
> implicitly (and quietly).

http://www.mysql.com/doc/en/CREATE_TABLE.html

Jon