I'm getting an error message when I run the following query:
it generates the error message:PHP Code:$query="LOAD DATA LOCAL INFILE '$filename' REPLACE INTO TABLE '$tablename'";
"campaigns" is the name of the table it is attempting to load the data into.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 ''campaigns'' at line 1
The $query statement is nearly identical to one I've used successfully in another application (only difference being this one I'm not specifying column names), and the data is, I believe, formatted correctly, using \t to separate the columns and \n to end each data line.
Any idea what I might be doing wrong?


Reply With Quote
;-)



