Hi.
I want to load a cvs file into my Db.
I've got this sql statement:
LOAD DATA LOCAL INFILE '/cvs.cvs'
INTO TABLE forum.categories
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(cat_name,cat_description)
My test file is like this:
value1,value2
value3,value4
I put the test file in my web root
but I've this mysql error #2000 😕
Where is the mistake ?
Take care.