Help Center/ GaussDB/ Service Overview/ Compatibility with MySQL Databases/ Centralized Instances/ MySQL Compatibility in M-Compatible Mode/ Unplanned Application Lossless and Transparent/ JSON Functions

Updated on 2024-11-11 GMT+08:00

View PDF

JSON Functions

**Table 1** JSON functions
MySQL	Support Unplanned ALT (Yes/No)
JSON_APPEND()	Supported
JSON_ARRAY()	Supported
JSON_ARRAY_APPEND()	Supported
JSON_ARRAY_INSERT()	Supported
JSON_CONTAINS()	Supported
JSON_CONTAINS_PATH()	Supported
JSON_DEPTH()	Supported
JSON_EXTRACT()	Supported
JSON_INSERT()	Supported
JSON_KEYS()	Supported
JSON_LENGTH()	Supported
JSON_MERGE()	Supported
JSON_MERGE_PATCH()	Supported
JSON_MERGE_PRESERVE()	Supported
JSON_OBJECT()	Supported
JSON_QUOTE()	Supported
JSON_REMOVE()	Supported
JSON_REPLACE()	Supported
JSON_SEARCH()	Supported
JSON_SET()	Supported
JSON_TYPE()	Supported
JSON_UNQUOTE()	Supported
JSON_VALID()	Supported

Parent topic: Unplanned Application Lossless and Transparent

Previous topic: Aggregate Functions

Next topic: Window Functions

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.