ERROR 1064 (42000): You have an error in your SQL syntax;

[Raghu K]

mysql> CREATE TABLE PRODUCT (
-> PROD_ID INTEGER primary,
-> CATG_ID INTEGER,
-> PROD_NAME VARCHAR(30),
-> SHORT_DESC VARCHAR(40),
-> LONG_DESC VARCHAR(60),
-> START_PRICE INTEGER,
-> CURRENT_PRICE INTEGER,
-> STATUS VARCHAR(30),
-> IMG_PATH VARCHAR(60),
-> BID_END_DATE DATETIME,
-> SELLER_ID INTEGER,
-> BUYER_ID INTEGER,
-> FINAL_PRICE INTEGER);
ERROR 1064 (42000): 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 '
CATG_ID INTEGER,
PROD_NAME VARCHAR(30),
SHORT_DESC VARCHAR(40),
LONG_DESC V' at line 2

Hi
can any one tell me,what is going wrong in the above SQL syntax.
Thanks in advance.


Raghu.