MySQL Forums
Forum List  »  Microsoft SQL Server

Local-name() in XML from MSSQL to MySQL
Posted by: Trung Tran
Date: March 18, 2022 06:58AM

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

Options: ReplyQuote


Subject
Written By
Posted
Local-name() in XML from MSSQL to MySQL
March 18, 2022 06:58AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.