Try changing this... category_id NUMERIC NOT NULL AUTO_INCREMENT, to this... category_id INT NOT NULL AUTO_INCREMENT,
or MEDIUMINT/BIGINT if you need that much. The INT type is the only type to accept an auto_increment qualifier. http://www.mysql.com/doc/en/CREATE_TABLE.html Hope this helps Roger -----Original Message----- From: Cesar Baquerizo [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 3:59 PM To: MySQL Subject: CREATE syntax wrong? Hello, I am on: mysql Ver 11.18 Distrib 3.23.54, for pc-linux (i686) Is there any reason the following should not work: CREATE TABLE category ( category_id NUMERIC NOT NULL AUTO_INCREMENT, category_name VARCHAR(40), description VARCHAR(80), PRIMARY KEY (category_id) ) TYPE=MyISAM; I get this: ERROR 1063 at line xx: Incorrect column specifier for column 'category_id' -- ------------------- Cesar Baquerizo Off. - 718.343.0829 Fax. - 718.343.3111 Cell - 917.685.8447 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
