>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) >); Silly thought ... don't you require a default value if a field is "NOT NULL" ? Rob