Importazione Load XML restituisce null

[danielix05]

Ciao a tutti, sto cercando di importare un file xml attraverso la seguente query

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

<?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

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
)

[danielix05]

[optime]

di che db stiamo parlando?

[danielix05]

MyISAM - InnoDB

[danielix05]

Aiuto!