Click to See Complete Forum and Search --> : Problems with mySQL C API


Whipping Boy
05-06-2001, 02:37 PM
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?