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
Attachment: [text/html]
Attachment: [text/html]
Attachment: [text/html]
