I am recieving the following error:
ERROR 1064 at line 16: You have an error in your SQL syntax near ''ACID YELLOW CGL','ACID','YELLOW','','3','15.06')' at line 1
The dump file looks like this:
CREATE TABLE classicdye (
id int (4) DEFAULT '0' NOT NULL AUTO_INCREMENT,
name text,
type text,
color text,
ci text,
quantity varchar(10),
price float(10,2),
PRIMARY KEY (id),
UNIQUE id (id)
);
INSERT INTO classicdye VALUES
(,'ACID YELLOW CGL','ACID','YELLOW','','3','15.06');
(,'ACID YELLOW NW 100%','ACID','YELLOW','','40','7.43');
(,'ACIDOL YELLOW G','ACID','YELLOW','','61','0.00' );
(,'AMO FAST YELLOW GN CONC','ACID','YELLOW','','25','8.10');
Anybody got any ideas? I am stumped (looking at code too long today)