mysql repair data 语句

修复数据统计错误：优化专家评价计数

最新推荐文章于 2025-09-08 20:55:49 发布

weixin_33795743

最新推荐文章于 2025-09-08 20:55:49 发布

阅读量133

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/ytfcz/p/3533136.html

本文介绍了一种方法，通过更新专家计数表来修正统计数据中缺失的专家评价数量，涉及EFFECT_SCORE、ATTITUDE_SCORE、PROMOTE_REASONABLE_SCORE、PRICE_REASONABLE_SCORE、ENVIRONMENT_SCORE等关键评分的汇总与更新。

1. 这条语句主要是用来修复一个表中的数据 ， 在另一个统计表中没有统计时，进行修改统计表的操作
        update expert_count ec inner join (
	     select  sum(e.EFFECT_SCORE) es_count,
		        sum(e.ATTITUDE_SCORE) as_count,
		        sum(e.PROMOTE_REASONABLE_SCORE) pro_count, 
			sum(e.PRICE_REASONABLE_SCORE) pri_count, 
		        sum(e.ENVIRONMENT_SCORE) env_count,
			count(e.effect_score) count_sum,
			expert_id
	       from evaluation e group by expert_id ) count_result
               on ec.expert_id = count_result.expert_id
	set   ec.received_evaluation_count = count_result.count_sum ,
		ec.EFFECT_SCORE = count_result.es_count,
		ec.ATTITUDE_SCORE = count_result.as_count,
		ec.PROMOTE_REASONABLE_SCORE = count_result.pro_count,
		ec.PRICE_REASONABLE_SCORE = count_result.pri_count,
		ec.ENVIRONMENT_SCORE = count_result.env_count ;

转载于:https://www.cnblogs.com/ytfcz/p/3533136.html