SELECT
CONCAT('{"检查所见":"',suojian ,'"',',','"检查结论":"',jielun ,'"}')
as json from shuchu2
组成json字符串:
SELECT
CONCAT('{"doc_model":"入参模型名称","doc_content":{"检查所见":"',suojian ,'"',',','"检查结论":"',jielun ,'"}}')
as json from shuchu2
SELECT
CONCAT('{"检查所见":"',suojian ,'"',',','"检查结论":"',jielun ,'"}')
as json from shuchu2
组成json字符串:
SELECT
CONCAT('{"doc_model":"入参模型名称","doc_content":{"检查所见":"',suojian ,'"',',','"检查结论":"',jielun ,'"}}')
as json from shuchu2