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