RE: [PHP-DB] Re: autoincrement

To add to that, yes, the column must be numeric and it must also be your PRIMARY KEY column to be able to have the autoincrement attribute, not just a regular index. - J -----Original Message----- From: Glenn Holden [mailto:glenn@nilenet.com] Sent: Tuesday, April 02, 2002 6:12 PM To: php-db@lists.php.net Subject: [PHP-DB] Re: autoincrement First, I think an AUTO_INCREMENT column must be a numeric column, not TEXT. Second, be sure this column is indexed. If you have trouble, send us the results of a DESCRIBE TABLE ajj47592.content; statement. That may help us give you some specific syntax to try. Glenn "Daniel Broome" <xake@zealous.net.nz> wrote in message news:20020403014035.7638.qmail@pb1.pair.com... > Here is the info that I used,I think there is something elce that I have to > do but I have done everything to my know how.. > > Please help > > SQL-query : > > ALTER TABLE ajj47592.content > CHANGE code code TEXT NOT NULL > AUTO_INCREMENT > > > MySQL said: > > > Incorrect column specifier for column 'code' > > > "Daniel Broome" <xake@zealous.net.nz> wrote in message > news:20020402033502.70611.qmail@pb1.pair.com... > > I am trying to add auto increment to a table I have already created in > > phpMyAdmin but I keeps coming up with an error. > > what can I do to fix this? > > > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php