Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

LOAD DATA LOCAL INFILE with C API

Status
Not open for further replies.
KurtWeber

KurtWeber

Programmer
May 6, 2001
2
US
import_set_query[] = "LOAD DATA LOCAL INFILE \"starter2000.set\" INTO TABLE OfficialSets";
mysql_query(spimport_db, import_set_query);

It returns with an error. mysql_error() tells me that the error is "You have an error in your SQL syntax near 'starter2000.set' at line 1"

However, if I input that query via the mysql client (minus the \, of course), it works just fine. What is wrong?

I'm using mySQL 3.23.36 on Slackware Linux using kernel 2.4.4.
 
Status
Not open for further replies.

Similar threads

lupidol
  • Locked
  • Question
mysql cannot add rows with "UNION" 1
Replies
5
Views
387
Chris Miller
Chris Miller
Marclem
  • Locked
  • Question
Get users Last Login Data 1
Replies
13
Views
1K
Marclem
Marclem
E
  • Locked
  • Question
MySQL calculator tools
Replies
0
Views
219
EdZzy
E
jyothi12389
  • Locked
  • Question
create a schedule and MYSQL loading csv data to table
Replies
0
Views
100
jyothi12389
jyothi12389
bharons
  • Locked
  • Question
function argument value, type or count is invalid
Replies
3
Views
331
bharons
bharons

Part and Inventory Search

Sponsor

Back
Top