[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