mysql update select
将b表查询结果更新到a表字段update A inner join(select id,name from B) c on A.id = c.id set A.name = c.name; 更新所有 member_num update lop_team t set t.member_num = (select count(tm.uid) from lop_team_memb...