[ic] autonumber with mySQL

Grant listbox at email.com
Wed Jan 14 18:40:29 EST 2004


> On Wed, 14 Jan 2004, Stefan Hornburg wrote:
>
> > > Database  correspondence  COLUMN_DEF  "code=INT(5) UNSIGNED
> AUTO_INCREMENT
> > > PRIMARY_KEY"
> >
> > Do I have another shot in the dark <g> ? I think you missing
> NOT NULL for
> > the code column.
>
> PRIMARY KEY implies NOT NULL. But I notice he wrote PRIMARY_KEY with an
> underscore, which is invalid SQL IIRC.

Ah!  I did get rid of that underscore at the same time that I added NOT
NULL.  I'll get rid of NOT NULL and leave PRIMARY KEY then.  Thanks!

- Grant



More information about the interchange-users mailing list