How to JSON in MySQL

This series covers how to solve common problems on JSON datasets with MySQL and it includes (links will appear once the target pages are up):

Common JSON questions

• How to load JSON data in MySQL?

Parse JSON

• How to extract a field from a JSON object in MySQL?
• How to extract an item from an array in a JSON object in MySQL?
• How to get the JSON field types in MySQL?

Create JSON

• How to create a JSON document from fields in MySQL?

Tabulate JSON

• How to tabulate a JSON document in MySQL?

Edit JSON

• How to merge JSON documents in MySQL?
• How to edit a JSON document in MySQL?
• How to insert a field in a JSON document in MySQL?

👉 If you want to try it out on a FREE MySQL database, check Aiven’s free plans

Originally published at https://ftisiot.net on July 21, 2023.