← Back to team overview

maria-discuss team mailing list archive

mariadb CONNECT XML table type question



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:

<Area type="countrycode">
<Area type="postalcode">
<Area type="municipality">

Is there a way to get a column for the value in e.g. area type=„countrycode"?

Any help is very much appreciated!