MySQL如何使用JSON函數

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.

還有很多方法，不再一一示範。

以上是MySQL如何使用JSON函數的詳細內容。更多資訊請關注PHP中文網其他相關文章！