mysql load data error

AmateurFlix · September 2nd, 2010, 11:04 PM

I'm getting an error message when I run the following query:

PHP Code:


			
$query="LOAD DATA LOCAL INFILE '$filename' REPLACE INTO TABLE '$tablename'";

it generates the error message:

Quote:

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

"campaigns" is the name of the table it is attempting to load the data into.
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?

b00bs · September 3rd, 2010, 12:43 AM

well, simply check the manual that corresponds to your MySQL

;-)

darksoul · September 3rd, 2010, 03:19 AM

lose the '' from tablename

Code:

$query="LOAD DATA LOCAL INFILE '$filename' REPLACE INTO TABLE $tablename";

AmateurFlix · September 3rd, 2010, 11:23 AM

thanks a bunch darksoul

I must've compared this query to my previous one a dozen times, somehow I missed the quotes.

September 3rd, 2010, 12:43 AM	#2 (permalink)
b00bs Professional Boobie Lover Join Date: Aug 2007 Posts: 616	well, simply check the manual that corresponds to your MySQL ;-) __________________ Software I recommend: Blogs Automater \| Blogs Organizer \| Links Organizer \| Gallery Scraper Sign up under me and I'll gladly help you setting up everything and give you tips how to use those scripts most effectively

September 3rd, 2010, 03:19 AM	#3 (permalink)
darksoul So Fucking Banned Join Date: Oct 2005 Posts: 786	lose the '' from tablename Code: $query="LOAD DATA LOCAL INFILE '$filename' REPLACE INTO TABLE $tablename"; __________________ Cam Booth Hot Babes

September 3rd, 2010, 11:23 AM	#4 (permalink)
AmateurFlix Who does #2 work for? Join Date: Oct 2005 Posts: 13,986	thanks a bunch darksoul I must've compared this query to my previous one a dozen times, somehow I missed the quotes. __________________ Traffic Trades - TGP & Toplist, Thumb & Text \| Porn Reviews \| Deutscher Porno Report