[ic] autonumber with mySQL

Jon Jensen jon at endpoint.com
Wed Jan 14 17:47:06 EST 2004

On Wed, 14 Jan 2004, Stefan Hornburg wrote:

> > Database  correspondence  COLUMN_DEF  "code=INT(5) UNSIGNED AUTO_INCREMENT
> 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.

> > I've got about 7 fields.  I let the rest use the default 128 setting.
> Where did you specify that default setting?

That's an Interchange built-in default: CHAR(128) unless otherwise

Just jumping into the fray.


More information about the interchange-users mailing list