Problem with syntax 4 creating 1 table

Ed Tue, 25 Oct 2005 15:41:02 -0700

Shawn green was very kindly helping me ouy trying to make mysql tables and I thought I had go the hang of it until I get this error-any ideas? Thanks a lot

CREATE TABLE PurchasedProducts(

`int_saleCart` INT AUTO_INCREMENT NOT NULL ,
`int_ClientID` INT,
`int_ProductID` INT,
`int_Quantity` INT,
`int_saleCart` PRIMARY KEY ( int_saleCart )

) ENGINE = MYISAM

MySQL said:

#1064 - 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 'PRIMARY KEY ( int_saleCart ) 
) 
ENGINE = MYISAM' at line 6

Here is what I'm trying to 
make:


PurchasedProducts:
int_saleCart 
int IDENTITY
int_ClientID int
int_ProductID int
int_Quantity 
int

Problem with syntax 4 creating 1 table

Reply via email to