MySQL Forums
Forum List  »  General

How to convert a JSON string containing map data to a TABLE.
Posted by: Steven Hughes
Date: May 14, 2022 11:35PM

I have a Java program executing mySQL stored procedures. The program is passing a JSON string, e.g. {"1": "classification", "2": "item", "3": "make", "4": "model", "5": "quantity", "6": "category"} and I need to turn it into a two column table. The first column is a number, the second is a value. I can't use PATH syntax as these values will change from execution to execution. How do I convert this string? Thanks, Steven.

Options: ReplyQuote




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.