Ik heb een fout in m'n query maar ik kom er niet meer uit.
Hier is mijn query:
$sql = "
LOAD DATA LOCAL INFILE '$bestand'
INTO TABLE reg
FIELDS TERMINATED BY ';'
LINES TERMINATED BY '\n'
(Reg_Mark, Reg_Nr, Name, Address, Zipp, Place, AC_Type, Engines, Serial_Nr, MAN, MTOW, AWCA, CofR, CofA, Rol, Cat, Phone, Own, ICAO_Code, ICAO_Type, CI, Noise_Req, TO, OF, FO, LFP, APP)
";Dit is de fout:
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 'to, of, fo, lfp, app)' at line 5
Alvast bedankt,
PH-MJS