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:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 6:12 PM To: [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php