How to tabulate a JSON document in MySQL
You can tabulate a JSON document (retrieve it as a row) in MySQL with the JSON_TABLE function.
How to remove a field in a JSON document in MySQL
You can remove a field from JSON document in MySQL with the JSON_REMOVE function.
How to insert a field in a JSON document in MySQL
You can insert a field in a JSON document in MySQL with the JSON_INSERT function.
How to edit a JSON document in MySQL
You can edit a JSON document in MySQL with:
- The
JSON_SETfunction that will replace values for JSON paths that exists and add values for the ones that don’t exist. - The
JSON_REPLACEfunction that will replace values for JSON paths that exists and ignore the ones that don’t exist.
How to merge JSON documents in MySQL
You can merge two JSON documents in MySQL with:
- the
JSON_MERGE_PRESERVEfunction to concatenate the document values - the
JSON_MERGE_PATCHfunction to keep the latest value for each key
How to create a JSON document from fields in MySQL
You can create a JSON document from fields in Mysql® with the JSON_OBJECT function
How to get the JSON field types in MySQL
To get the type of a JSON item in MySQL you need to use the JSON_TYPE function.
How to extract an item from an array in a JSON object in MySQL
To extract an item from an array in MySQL you need to use the -> operator and the [item_number] JSON Path Syntax.
How to extract a field from a JSON object in MySQL
Mysql® offers three main ways to extract fields from a JSON document:
- the
->operator to extract the field as JSON - the
->>operator to extract the field as text - the
JSON_EXTRACTfunction
Both operators use the JSON Path Syntax
How to load JSON data in MySQL?
To load JSON data into a MySQL column you need to include it as string.
