Comments - Knowledge Base Questions

used following sql: DROP TABLE IF EXISTS Food;

CREATE TABLE food ( catalog_number INT(6) NOT NULL AUTO_INCREMENT, name VARCHAR(20) NOT NULL, added_date DATE NOT NULL, category VARCHAR(20) NOT NULL, type VARCHAR(20) NOT NULL, description VARCHAR(255) NOT NULL, price DECIMAL(7,2) NOT NULL, pix VARCHAR(20) NOT NULL DEFAULT 'Missing.jpg', PRIMARY KEY(catalog_number) );

INSERT INTO `food` VALUES (1,'Navel','2005-01-03','Fruit','Oranges','Sweet, juicy.','2.10','Missing.jpg'); INSERT INTO `food` VALUES (3,'Romaine','2005-01-03','Vegetables','Lettuce','Leafy, crispy.','1.10','Missing.jpg'), INSERT INTO `food` VALUES (4,'Delicious','2005-01-05','Fruit','Apples','Bright red, sweet, fresh, crispy.','1.10','Missing.jpg'), INSERT INTO `food` VALUES (6,'Red Leaf','2005-01-05','Vegetables','Lettuce','Red leaf, fresh, crispy.','1.20','Missing.jpg'), INSERT INTO `food` VALUES (8,'Butter','2005-01-06','Vegetables','Lettuce','Gread head, fresh, crispy.','2.20','Missing.jpg'), INSERT INTO `food` VALUES (9,'Granny Smith','2005-01-19','Fruit','Apples','Green, tart, crisp, fresh, solid.','1.20','Missing.jpg'), INSERT INTO `food` VALUES (10,'Gala','2005-01-19','Fruit','Apples','Mellow taste, fresh, crisp.','1.25','Missing.jpg'), INSERT INTO `food` VALUES (11,'Fuji','2005-01-20','Fruit','Apples','Yellow, mellow, crisp, fresh.','1.50','Missing.jpg'), INSERT INTO `food` VALUES (12,'Roma','2005-01-06','Vegetables','Tomatoes','Bright red, sweet, fresh, crispy.','0.99','Missing.jpg')

unfortunately can't get the inserts to work. Please help Ralph Kessel kesselr1@mchsi.com