Hi AUTO_INCREMENT needs to be an integer, NUMERIC is a decimal?
not 100% sure but it looks like it Peter -----Original Message----- From: Cesar Baquerizo [mailto:[EMAIL PROTECTED] Sent: 24 March 2003 20:59 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]