update 一个表的值到另一个表

sql的update语句新写法

update pvp_worlds,(select count(pl.server_from) as totol,pl.server_from as serid from (select count(distinct u_id),server_from  from player_info where player_info.p_citys >0 group by u_id) as pl left join pvp_worlds on pl.server_from = pvp_worlds.serverid group by pl.server_from) as p set num = p.totol where p.serid = pvp_worlds.serverid;