CREATE syntax wrong?

[Cesar Baquerizo]

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

signature.asc
Description: This is a digitally signed message part