Posted by Jaceq on 12/31/05 15:07

Jaceq wrote:
> Hello!
> I'm trying to do query:
> CREATE TABLE gracze (
> nr NUMERIC NOT NULL AUTO_INCREMENT,
> login VARCHAR(40),
> sila NUMERIC(4),
> zrecznosc NUMERIC(4),
> wytrzymalosc NUMERIC(4),
> wiedza NUMERIC(4),
> nr_etapu NUMERIC(3) NOT NULL,
> PRIMARY KEY (nr, nr_etapu),
> KEY IDX_gracze1(nr_etapu)
> );
> And it doesn't work :(
> I got error:
> #1063 - Incorrect column specifier for column 'nr'
>
> I know the "auto_increment" is the problem here, but I don't know why
> (if I erase auto_increment option it works fine), I really need auto
> increment at this point, does any one know what is going on?
> I'm using MySQL 4.1.16 (from FC4)
> Please help

I solved it myself ;)
nr NUMERIC NOT NULL AUTO_INCREMENT,
this is BAD
and this is ok:
nr INT NOT NULL AUTO_INCREMENT,
:)

• Next in forum: Re: TRUNCATE and OPTIMIZE from Access to MySQL
• Prev in forum: problem with auto_increment
• Thread view: Re: problem with auto_increment

[Reply to this message]