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.
"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
> do but I have done everything to my know how..
> Please help
> SQL-query :
> ALTER TABLE `ajj47592`.`content` CHANGE `code` `code` TEXT NOT NULL
> 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