I'm having a problem with the local local infile command used to import values from a csv to a mysql table. My code (in php is...)
I get the error message "The used command is not allowed with this MySQL version". Is my syntax messed up, or do I need to change something to get this to work?
mysql_query("LOAD DATA LOCAL INFILE 'C:/Documents and Settings/user/My Documents/stuff.TXT' INTO TABLE db.change FIELDS TERMINATED BY ',' (field1,field2,field3,field4)") or die(mysql_error());