MySQL Create JSON Values

方法	描述
JSON_ARRAY([val[, val] ...])
JSON_OBJECT([key, val[, key, val] ...])
JSON_QUOTE(string)

1.JSON_ARRAY([val[, val] ...])

SELECT JSON_ARRAY(1, "abc", NULL, TRUE, CURTIME()); -- [1, "abc", null, true, "11:30:24.000000"]

2.JSON_OBJECT([key, val[, key, val] ...])

SELECT JSON_OBJECT('id', 87, 'name', 'carrot');  -- {"id": 87, "name": "carrot"} 

3.JSON_QUOTE(string) 将json_val用"号括起来,就是变成字符串的意思

SELECT JSON_QUOTE('[1,2,3]'); -- "[1,2,3]" 

参考:
https://dev.mysql.com/doc/refman/8.0/en/json-creation-functions.html