[Maria-discuss] mariadb CONNECT XML table type question
29 Aug
2018
29 Aug
'18
3:51 p.m.
Hi,
I am using CONNECT for some XML files, but lately came to a problem I was unable to solve so far.
The XML has the following structure:
<PhysicalLocation> <Name>Address</Name> <Area type="countrycode"> <Value>DE</Value> </Area> <Area type="postalcode"> <Value>70173</Value> </Area> <Area type="municipality"> <Value>Stuttgart</Value> </Area> </PhysicalLocation>
Is there a way to get a column for the value in e.g. area type=„countrycode"?
Any help is very much appreciated!
Thanks! Björn
2091
Age (days ago)
2091
Last active (days ago)
0 comments
1 participants
participants (1)
-
Björn Hayer