I am trying to use PHP to process the following MySql Command. This works when typed directly into MYSql but returns an error when I try to use mysql_query() from PHP4
LOAD DATA LOCAL INFILE '/br_data/BR_RES.txt' INTO TABLE BR_RES_temp FIELDS TERMINATED BY '|' ENCLOSED BY '\"' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;
the error:
You have an error in your SQL syntax near '\n' ' at line 1
I have tried all varieties for the new line
\\n and \\\n.
None seem to work,
Any one have any ideas,
Andrew
LOAD DATA LOCAL INFILE '/br_data/BR_RES.txt' INTO TABLE BR_RES_temp FIELDS TERMINATED BY '|' ENCLOSED BY '\"' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;
the error:
You have an error in your SQL syntax near '\n' ' at line 1
I have tried all varieties for the new line
\\n and \\\n.
None seem to work,
Any one have any ideas,
Andrew