I think I've been looking at this too long to be able to see the error can somebody tell me what's worng with this snippet of code?
$load_sql = "LOAD DATA LOCAL INFILE '$File' INTO TABLE upload(toplevel,section,subsection,sku,description,schedule,pline,price)
FIELDS TERMINATED BY '\\t' OPTIONALLY ENCLOSED BY '\"'
ESCAPED BY '\\\\' LINES TERMINATED BY '\\r\\n'
";
It produces this error:
1064: You have an error in your SQL syntax near 'FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '\"' ESCAPED B' at line 2
I can't see anything wrong with line 2!!! I've tried it using \t \\t \\\t " \" \\\"
Aaaaaaaaagghhhhhh.
-- Nick Gushlow.
$load_sql = "LOAD DATA LOCAL INFILE '$File' INTO TABLE upload(toplevel,section,subsection,sku,description,schedule,pline,price)
FIELDS TERMINATED BY '\\t' OPTIONALLY ENCLOSED BY '\"'
ESCAPED BY '\\\\' LINES TERMINATED BY '\\r\\n'
";
It produces this error:
1064: You have an error in your SQL syntax near 'FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '\"' ESCAPED B' at line 2
I can't see anything wrong with line 2!!! I've tried it using \t \\t \\\t " \" \\\"
Aaaaaaaaagghhhhhh.
-- Nick Gushlow.