mysql更新求和的值_mysql 子查询 求和更新数据?报错-问答-阿里云开发者社区-阿里云...

现在会员A表， 另一张B表，

现在我想用一条语句把A表里的会员在B表里的数据求和后更新到A表！

UPDATE record r, user u SET u.service_time=sum(r.service_time) WHERE r.user_uid = u.uid AND r.service_time <> 0 AND r.is_check = 1; 上面语句不行，然后我用了下面个子查询

update user u, (select sum(service_time) as total, user_uid from record where service_time <> 0 AND is_check = 1) r set u.service_time=r.total where r.user_uid = u.uid;

上面也不行，虽然没有报错，但是执行下去，并没有更新到数据！然后我把条件移到了子查询内也不行！

update user u, (select sum(service_time) as total, user_uid from record where service_time <> 0 AND is_check = 1) r set u.service_time=r.total where r.user_uid = u.uid;

在此感谢大家的帮忙！