根据select出来的数据进行update

时间：2018-06-20 23:21:15 收藏：0 阅读：688

update 
  t_tbl_desc
set 
  num=b.num
from
  t_tbl_desc a,
  (select distinct(name) as name,count(name) num  from t_col_desc  group by name)b
where
   a.name=b.name

原文：https://www.cnblogs.com/xinzhyu/p/9206365.html