MySQL Forums
Forum List  »  General

Re: How to convert a JSON string containing map data to a TABLE.
Posted by: Steven Hughes
Date: May 16, 2022 11:54AM

That is most disappointing and a curious oversight.

There is a function to split arrays but not maps?

I was able to extract the key values to use as PATH separators but it appears all PATH values must be literals, they cannot be variables.

I am trying to port an SQL Server application, which uses JSON stored procedures, to MySQL. I shall have to report back that is cannot be done.

Thank you for your input.


Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

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.