SELECT
GROUP_CONCAT(
CONCAT(
CONCAT("{\"userName\": \"", userName, "\""),
CONCAT(", \"email: \"", email, "\"}")
)
)
AS json FROM User;
SELECT
GROUP_CONCAT(
CONCAT(
CONCAT("{\"userName\": \"", userName, "\""),
CONCAT(", \"email: \"", email, "\"}")
)
)
AS json FROM User;
转载于:https://www.cnblogs.com/Smily-C/p/3891667.html