MySql 查询字段转成JSON字符串

菜鸟 Ongal

于 2024-12-19 09:44:40 发布

阅读量188

点赞数 1

文章标签： java sql mysql

本文链接：https://blog.csdn.net/bboyOA/article/details/144576312

版权

cast( 
	concat( 
		'[', 
		group_concat( 
			concat( 
				'{\"year\":\"', 
				info.rlc144_year, 
				'\",\"assessmentType\":\"', 
				info.assessmentType, 
				'\",\"assessmentTypeName\":\"', 
				info.assessmentTypeName, 
				'\",\"assessmentEvaluation\":\"', 
				info.assessmentEvaluation, 
				'\",\"isSrgz\":\"', 
				info.isSrgz, 
				'\",\"fileId\":\"', 
				info.fileId, 
				'\",\"fileName\":\"', 
				info.fileName, 
				'\"}'  
			)  
		), 
		']'  
	) AS CHAR ( 300000 ) charset utf8  
) AS `dataJson`