[thelist] Create tables on Local MySql

[Andrew Maynes]

I have just run a query on win98 Mysql DB (the one I am having problems
connecting to!!) as I would normally do on an online server and it kicked out
the error below the query? Something is wrong and I haven't the foggist

CREATE TABLE CartItems (
UserID VARCHAR(100) NOT NULL,
ItemID VARCHAR(25) NOT NULL,
ItemQuantity INT(4) NOT NULL,
Date VARCHAR(100) NOT NULL,
CartItemsID BIGINT NOT NULL AUTO_INCREMENT,
PRIMARY KEY (CartItemsID)
);


You have an error in your SQL syntax near ';

CREATE TABLE CartItems (
UserID VARCHAR(100) NOT NULL,
ItemID VARCHAR(25)' at line 22
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.384 / Virus Database: 216 - Release Date: 8/21/02