MySql 查询字段转成JSON字符串

最新推荐文章于 2025-03-11 00:12:55 发布

原创最新推荐文章于 2025-03-11 00:12:55 发布 · 220 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java #sql #mysql

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`