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
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" <[E
Here is the info that I used, I know that there is something else that I
have to
add but I have done everything that I know...
Please help...
SQL-query :
ALTER TABLE `ajj47592`.`content` CHANGE `code` `code` TEXT NOT NULL
AUTO_INCREMENT
MySQL said:
Incorrect column specifier for column 'code'
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'
"
What's the error?
Do you already have an auto-inc field?
Have you tried it with another interface? Ie: directly in the MySQL command
line util.
Glenn
Notes from MySQL.com:
There can be only one AUTO_INCREMENT column per table, and it must be
indexed.
When you add an AUTO_INCREMENT column, column