Re: autoincrement
| From: | Glenn Holden | Date: | Wed, 03 Apr 2002 02:11:44 +0000 |
| Subject: | Re: autoincrement | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-18148@lists.php.net to get a copy of this message | ||
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?
> >
> >
>
>