You can edit a JSON document in MySQL with:
JSON_SET function that will replace values for JSON paths that exists and add values for the ones that don’t exist.JSON_REPLACE function that will replace values for JSON paths that exists and ignore the ones that don’t exist.You can merge two JSON documents in MySQL with:
JSON_MERGE_PRESERVE function to concatenate the document valuesJSON_MERGE_PATCH function to keep the latest value for each keyYou can create a JSON document from fields in Mysql® with the JSON_OBJECT function
To get the type of a JSON item in MySQL you need to use the JSON_TYPE function.
To extract an item from an array in MySQL you need to use the -> operator and the [item_number] JSON Path Syntax.
MySQL® offers three ways to extract fields from a JSON object:
-> operator to extract the field as JSON->> operator to extract the field as textJSON_EXTRACT functionBoth operators use the JSON Path Syntax
To load JSON data into a MySQL column you need to include it as string.
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):
So… what does a Staff Developer Advocate do, and how is it different from the Senior Developer Advocate role you were doing before?
I got this question three times in the last two weeks after my promotion from Senior to Staff (🎉🎉🎉🎉), from various people in my network.
