JSON函數(5.7版本才支援)
指令：json_object(函數)
作用：轉換json字串
##應用程式場景：指定資料轉換json字串
範例：
1 2 3 4 5 6 7 | 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:
1 2 3 4 5 6 7 | 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():
1 | select json_valid('{"name": "andyqian", "database": "MySQL"}');
|
登入後複製
其中為有效json字串時為1。
無效json字串時為0.
還有很多方法，不再一一示範。
以上是MySQL如何使用JSON函數的詳細內容。更多資訊請關注PHP中文網其他相關文章！
