22 lines
732 B
Java
22 lines
732 B
Java
### 心率原始数据修正
|
|
update watch_data_heart_rate set silence_value = null where silence_value = 0.00;
|
|
|
|
|
|
### 心率日汇总表数据修正
|
|
UPDATE watch_stat_user_info_day_heart_rate stat
|
|
LEFT JOIN (
|
|
SELECT
|
|
bind_user_id,
|
|
ifnull( max( silence_value ), 0 ) AS silence_max_value,
|
|
ifnull( min( silence_value ), 0 ) AS silence_min_value,
|
|
ifnull( avg( silence_value ), 0 ) AS silence_avg_value,
|
|
data_date
|
|
FROM
|
|
watch_data_heart_rate
|
|
GROUP BY
|
|
bind_user_id,
|
|
data_date
|
|
) DATA ON stat.user_id = DATA.bind_user_id
|
|
SET stat.silence_max_value = DATA.silence_max_value,
|
|
stat.silence_min_value = DATA.silence_min_value,
|
|
stat.silence_avg_value = DATA.silence_avg_value; |