Ciao a tutti, sto cercando di importare un file xml attraverso la seguente query
codice:
LOAD XML LOCAL INFILE "https://www.sito.xxx/file.xml"
INTO TABLE xml_test_wb
ROWS IDENTIFIED BY '<member>'; // provato anche con <struct>
ma sul db viene salvato sempre NULL. Grazie per l'attenzione.
file.xml
codice:
<?xml version="1.0" encoding="utf-8"?>
<value>
<array>
<data>
<value>
<int>0</int>
</value>
<value>
<array>
<data>
<value>
<struct>
<member><name>id_channel</name>
<value><int>156</int></value>
</member>
<member><name>special_offer</name>
<value><string></string></value>
</member>
<member><name>reservation_code</name>
<value><int>ref-2587</int></value>
</member>
<member><name>dayprices</name>
<value>
<struct>
<member>
<name>12</name>
<value>
<array>
<data>
<value><double>51</double></value>
<value><double>52</double></value>
</data>
</array>
</value>
</member>
</struct>
</value>
</member>
<member><name>arrival_hour</name>
<value><string>10:00</string></value>
</member>
</struct>
</value>
</data>
</array>
</value>
</data>
</array>
</value>
tabella sql
codice:
CREATE TABLE `db_table`.`xml_test_wb` (
`id_channel` VARCHAR( 255 ) DEFAULT NULL ,
`reservation_code` VARCHAR( 255 ) DEFAULT NULL ,
`dayprices` VARCHAR( 255 ) DEFAULT NULL ,
`arrival_hour` VARCHAR( 255 ) DEFAULT NULL ,
`rooms_occupancies` VARCHAR( 255 ) DEFAULT NULL ,
`booked_rooms` VARCHAR( 255 ) DEFAULT NULL ,
`discount` VARCHAR( 255 ) DEFAULT NULL ,
`code` VARCHAR( 255 ) DEFAULT NULL
)