[ic] autonumber with mySQL

Jon Jensen jon at endpoint.com
Wed Jan 14 18:43:00 EST 2004

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).



More information about the interchange-users mailing list