MySQL :: MySQL 8.0 Labs: JSON aggregation functions

In MySQL 5.7 we introduced JSON functionality into the MySQL Server. This work included the introduction of a JSON data type, virtual columns and a set of approximately 20 SQL functions that allow you to manipulate and search JSON data on the server side. The JSON functionality has been well received, and in MySQL 8.0 we have plans to improve it in a number of ways. This post outlines improvements

[inoueyuworks]

group by のときの結果を json に aggregate する。

[PaulYamamoto]

JSON_ARRAYAGG・JSON_OBJECTAGG関数が追加され集約結果をJSONとして出力できる様になった