Local-name() in XML from MSSQL to MySQL

[Trung Tran]

Hi experts,

I'm working on migrating some codes from MSSQL to MySQL, but I don't know the equivalent of local-name()in MySQL.

The original MSSQL code is as followed:

<Attributes>
<Map>
<entry key="Trigger" value = "Action">
<value>
<Map>
<entry key=" Processing">
<value>
<Boolean>true</Boolean>
</value>
</entry>
</Map>
</value>
</entry>
</Map>
</Attributes>

The output is:
AttrKey ||AttrValue ||ValueType
Trigger ||Action ||Map

1. How we can apply similar to local-name() in MySQL to return the ValueType = "Map"? When I tried something like "//*[local-name()]" in MySQL, it returned error.

2.And what is the "." in "(.)" meaning?

Really appreciate your support.

TIA