I am using EasyPHP on windows.
CODE:
$ffname = realpath("db\application.dat");
$query = "
LOAD DATA INFILE LOCAL '$ffname'
INTO TABLE $tablename
FIELDS TERMINATED BY '|'
LINES TERMINATED BY '\
'
(fields...)";
$conn->query($query);
ERROR:
failed : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LOCAL 'C:\Program Files (x86)\EasyPHP-DevServer-14.1VC11\data\localweb\projects\' at line 1
ECHO OF QUERY:
LOAD DATA INFILE LOCAL 'C:\Program Files (x86)\EasyPHP-DevServer-14.1VC11\data\localweb\projects\projectname\db\file.dat' INTO TABLE application FIELDS TERMINATED BY '|' LINES TERMINATED BY '
' (some fields here)