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
