Re: Auto Increments and Other Keys

> All - Running MySQL 4.0.17 under Red Hat 9, using MyISAM tables. > > I'm trying to add the auto_increment attribute to column in a table that > already has a primary key defined. Here is the table I'm trying to > create: > > > CREATE TABLE IF NOT EXISTS dataTypes ( > id int unsigned NOT NULL

Re: Auto Increments and Other Keys

> All - Running MySQL 4.0.17 under Red Hat 9, using MyISAM tables. > > I'm trying to add the auto_increment attribute to column in a table that > already has a primary key defined. Here is the table I'm trying to > create: > > > CREATE TABLE IF NOT EXISTS dataTypes ( > id int unsigned NOT NULL AU

Re: Auto Increments and Other Keys

Mark Riehl <[EMAIL PROTECTED]> wrote: > All - Running MySQL 4.0.17 under Red Hat 9, using MyISAM tables. > > I'm trying to add the auto_increment attribute to column in a table that > already has a primary key defined. Here is the table I'm trying to create: > > > CREATE TABLE IF NOT EXISTS da

Auto Increments and Other Keys

All - Running MySQL 4.0.17 under Red Hat 9, using MyISAM tables. I'm trying to add the auto_increment attribute to column in a table that already has a primary key defined. Here is the table I'm trying to create: CREATE TABLE IF NOT EXISTS dataTypes ( id int unsigned NOT NULL AUTO_INCREMENT KEY