MySQL如何使用JSON函数
作者:WeekendLife
时间:2023-05-01
浏览:4
JSON函数(5.7版本才支持)命令:json_object(函数)作用:转换json字符串应用场景:指定数据转换json字符串例子:mysql>selectjson_object("name","andyqian","database","MySQL");+---------------------------------------------------+|json_object("name","andyqian","database","MySQL")|+---------------------
本文目录
JSON函数(5.7版本才支持)
命令:json_object(函数)
作用:转换json字符串
应用场景:指定数据转换json字符串
例子:
mysql> select json_object("name","andyqian","database","MySQL");
+---------------------------------------------------+
| json_object("name","andyqian","database","MySQL") |
+---------------------------------------------------+
| {"name": "andyqian", "database": "MySQL"} |
+---------------------------------------------------+
1 row in set (0.00 sec)其中包括json_array:
mysql> select json_array("name","andyqian","database","MySQL");
+--------------------------------------------------+
| json_array("name","andyqian","database","MySQL") |
+--------------------------------------------------+
| ["name", "andyqian", "database", "MySQL"] |
+--------------------------------------------------+
1 row in set (0.00 sec)判断是否为json字符串的json_valid():
select json_valid('{"name": "andyqian", "database": "MySQL"}');其中为有效json字符串时为1。
无效json字符串时为0.
还有很多方法,不再一一演示。
作者最新文章
AO3官网快速入口推荐 AO3最新可用网址
2026-11-21 10:08
TapTap海外版官网入口及网址汇总
2026-11-19 17:36
抖音猜你想搜能说明对方搜过吗
2026-11-19 15:27
电脑黑屏怎么解决?开机黑屏 只有鼠标等情况排查步骤
2026-11-08 23:28
process lasso怎么关闭开机自动启动
2026-11-01 09:22
热门文章
更多
精品专题
更多
Mac软件
更多
WINDOWS
更多

































