Mysql 中的Json函数大全

最新推荐文章于 2024-06-14 16:48:38 发布

icefireicefire

最新推荐文章于 2024-06-14 16:48:38 发布

阅读量302

点赞数

分类专栏： mysql JSON

本文链接：https://blog.csdn.net/wjb200125042/article/details/119832671

版权

mysql 同时被 2 个专栏收录

6 篇文章 0 订阅

订阅专栏

JSON

1 篇文章 0 订阅

订阅专栏

本文详细介绍了MySQL中用于处理JSON数据类型的函数，包括JSON_EXTRACT、JSON_UNQUOTE、JSON_APPEND、JSON_ARRAY等，以及它们在实际操作JSON文档中的用法。从插入、提取、修改到查询JSON数据，这些函数提供了强大的支持，适用于需要处理JSON格式数据的数据库操作。

摘要由CSDN通过智能技术生成

Name	Description	Introduced	Deprecated
`->`	Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT().
`->>`	Return value from JSON column after evaluating path and unquoting the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()).	5.7.13
`JSON_APPEND()`	Append data to JSON document		Yes
`JSON_ARRAY()`	Create JSON array
`JSON_ARRAY_APPEND()`	Append data to JSON document
`JSON_ARRAY_INSERT()`	Insert into JSON array
`JSON_CONTAINS()`	Whether JSON document contains specific object at path
`JSON_CONTAINS_PATH()`	Whether JSON document contains any data at path
`JSON_DEPTH()`	Maximum depth of JSON document
`JSON_EXTRACT()`	Return data from JSON document
`JSON_INSERT()`	Insert data into JSON document
`JSON_KEYS()`	Array of keys from JSON document
`JSON_LENGTH()`	Number of elements in JSON document
`JSON_MERGE()`	Merge JSON documents, preserving duplicate keys. Deprecated synonym for JSON_MERGE_PRESERVE()		5.7.22
`JSON_MERGE_PATCH()`	Merge JSON documents, replacing values of duplicate keys	5.7.22
`JSON_MERGE_PRESERVE()`	Merge JSON documents, preserving duplicate keys	5.7.22
`JSON_OBJECT()`	Create JSON object
`JSON_PRETTY()`	Print a JSON document in human-readable format	5.7.22
`JSON_QUOTE()`	Quote JSON document
`JSON_REMOVE()`	Remove data from JSON document
`JSON_REPLACE()`	Replace values in JSON document
`JSON_SEARCH()`	Path to value within JSON document
`JSON_SET()`	Insert data into JSON document
`JSON_STORAGE_SIZE()`	Space used for storage of binary representation of a JSON document	5.7.22
`JSON_TYPE()`	Type of JSON value
`JSON_UNQUOTE()`	Unquote JSON value
`JSON_VALID()`	Whether JSON value is valid