Export from XML to MySQL key and value -

hello i'm trying import data of sommets http://overpass-turbo.eu/ in xml format db.

the xml output is:

<node id="45160922" lat="42.6454747" lon="1.5187225">     <tag k="ele" v="2682"/>     <tag k="name" v="pic des fangasses"/>     <tag k="natural" v="peak"/>   </node>   <node id="45160950" lat="42.5902481" lon="1.4341757">     <tag k="ele" v="2860"/>     <tag k="name" v="agulla de baiau"/>     <tag k="natural" v="peak"/>   </node>   <node id="45160958" lat="42.6037200" lon="1.4419886">     <tag k="ele" v="2914"/>     <tag k="name" v="pic de medecourbe"/>     <tag k="name:ca" v="pic de medacorba"/>     <tag k="natural" v="peak"/>   </node> 

i tried following code imports lat , lon values:

load xml local infile 'sommets_and.xml' table sommets_and_copy1 rows identified '<node>' 

any import on same row ele , name values? i'm searching like:

|    id    |       name      |     lat    |    lon    |    ele  |  |  00001   |pic des fangasses| 42.6454747 | 1.5187225 |   2682  | 

thanks help!

finally have solved problem, if it's useful anyone:

1) export data in .json (http://overpass-turbo.eu)

2) data .json .csv

3) import .csv tables