【SQL进阶】多表关联 update（用户积分奖励)

users_buy 字段说明：

1、id  自增ID

2、user_name 用户名

3、paymoney 消费金额

4、paydate  消费日期

update users_score a INNER JOIN 
(select max(paymoney) as mp,user_name from users_buy group by user_name ) b 
on a.user_name=b.user_name 
set a.user_score= a.user_score+(b.mp*0.1)