Posted by Jaceq on 12/31/05 14:13

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

[Back to original message]