MySQL Error 1064 (42000)

Databases
1

Could someone tell me what is wrong with this script…

LOAD DATA LOCAL INFILE Book1.csv
INTO TABLE page
FIELDS TERMINATED BY ‘,’
LINES TERMINATED BY ’ ’
(id, caption)

I am trying to upload book1.csv into the database ‘page’
It only has two fields currently, 'id and ‘caption’ and whenever I try to run it, I get the error 1064 (42000) near 'Book1.csv INTO TABLE page FIELDS TERMINATED BY ‘,’ LINES TERMINATED BY ’ ’ (id,".

Anyone know why?

2

put the file name in quotes

3

THanks, I appreciate the quick reply…it’s fixed