Saturday, 10 January 2015

LOAD XML LOCAL INFILE phpmyadmin Error #1064



I've to import an XML file with inconsistent Column Names into my database. I use this SQL:




LOAD XML LOCAL INFILE 'http://ift.tt/1C03oMK'
INTO TABLE Original_xml
SET codiceproduttore = Cod.,
categoria_merceologica_primaria = Categoria,
categoria_merceologica_secondaria = Sottocategoria,
disponibilita_sede = Q.tà disponibile,
ean = Cod. a barre,
sconto = extra 1,
prezzo_netto = Prezzo forn.


When i execute the query in phpmyadmin, it returns this error



#1064 - 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 'XML LOCAL INFILE 'http://ift.tt/1AGKmxE' at line 1

Do I have to enable the LOAD "module" in php.ini? How can i do this?


No comments:

Post a Comment