11.10.3 JSON_PRETTY(json_doc)函数
JSON_PRETTY(json_doc)函数以优雅的格式显示JSON数据。使用示例如下:
mysql> SELECT JSON_PRETTY(content) FROM test_json WHERE id = 1;
+----------------------------------------------------------------------+
| JSON_PRETTY(content) |
+----------------------------------------------------------------------+
| {
"age": 18,
"name": "binghe",
"address": {
"city": "chengdu",
"province": "sichuan"
}
} |
+----------------------------------------------------------------------+
1 row in set (0.00 sec)