Kļūda pie tabulas izveides MySQL

[Sasa]

Kļūdas paziņojums:

 

Kļūda

 

SQL vaicājums:

 

CREATE TABLE `katalogs`.`accessories` (
`accs_id` BIGINT( 20 ) UNSIGNED NOT NULL NOT NULL AUTO_INCREMENT PRIMARY KEY,
`product_id` BIGINT( 20 ) UNSIGNED NULL ,
`drillQty` SMALLINT( 10 ) UNSIGNED NULL ,
`edgeMatrlQty` DOUBLE( 10 ) NULL ,
`picture` VARCHAR( 200 ) NULL ,
PRIMARY KEY ( `accs_id` )
) ENGINE = MYISAM

 

MySQL teica: Dokumentācija

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') NULL, `picture` VARCHAR(200) NULL, PRIMARY KEY (`accs_id`)) ENGINE = MyISAM' at line 1

Edited June 5, 2009 by Sasa

[bubu]

DOUBLE nav jānorāda gan M, gan D vai nu reizē, vai arī neviens no abiem?

http://dev.mysql.com/doc/refman/5.1/en/num....html#id4158822

[Klez]

`accs_id` BIGINT( 20 ) UNSIGNED NOT NULL NOT NULL AUTO_INCREMENT PRIMARY KEY,