Skip navigation links

MySQL Forums :: MySQL Query Browser :: ERROR 1064 (42000): You have an error in your SQL syntax;


Advanced Search

ERROR 1064 (42000): You have an error in your SQL syntax;
Posted by: Raghu K ()
Date: March 18, 2008 04:57AM

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.

Options: ReplyQuote


Subject Written By Posted
ERROR 1064 (42000): You have an error in your SQL syntax; Raghu K 03/18/2008 04:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.