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 ' '
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?
put the file name in quotes
THanks, I appreciate the quick reply...it's fixed