如何将以下查询转换为json?
SELECT id ,name ,AddTime(created_at ,'04:30:00') as created_at2
我的意思是我需要这样的东西:
"select":[ "id","name" ],
"from":[
"table_name"
],
但我不知道如何使用AddTime(created_at ,'04:30:00') as created_at2
似乎您正在寻找JSON_OBJECT()
函数来构造JSON值,如
SELECT JSON_OBJECT(
'id', id,
'name', name,
'created_at2', AddTime(created_at ,'04:30:00')
) AS js
FROM t
演示
编辑:也许您需要添加JSON_ARRAY()
功能,如
SELECT JSON_OBJECT( 'select',
JSON_ARRAY( id, name, AddTime(created_at ,'04:30:00') )
) AS js
FROM t
演示