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, 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.