mysql 根据查询信息更新数据库

UPDATE gift g INNER JOIN (SELECT sum(count) as total,sku_code FROM gift_order GROUP BY sku_code ) as gd SET g.exchanges_total = gd.total WHERE g.sku_code = gd.sku_code

如果要根据查询信息更新数据的话，INNER JOIN是必须的。剩下的一目了然，where语句随便加！