SELECT
GROUP_CONCAT(
CONCAT(
CONCAT("{\"userName\": \"", userName, "\""),
CONCAT(", \"email: \"", email, "\"}")
)
)
AS json FROM User;
Smily-C 2014-08-05 10:26 原文
SELECT
GROUP_CONCAT(
CONCAT(
CONCAT("{\"userName\": \"", userName, "\""),
CONCAT(", \"email: \"", email, "\"}")
)
)
AS json FROM User;