[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
2306
Age (days ago)
2306
Last active (days ago)
0 comments
1 participants
participants (1)
-
Björn Hayer