SQL语句修改,如何将下面的insert语句改为update语句。

发布网友发布时间：2024-10-13 13:37

共2个回答

热心网友时间：2024-12-04 07:42

-- for M$SQL
update a set
  error = b.error
  , normal = b.normal
  , unknown = b.unknown
  , exectime = getdate()
from r_count as a
join (
  select type,
    sum(case when flag=0 then 1 else 0 end) as "error",
    sum(case when flag=1 then 1 else 0 end) as "normal",
    sum(case when flag=2 then 1 else 0 end) as "unknown",
  from R_NewsUser_Netbar
  group by type
) as b on 1=1
  and 'News' = a.type
  and b.type = a.xtype

热心网友时间：2024-12-04 07:43

你要更新什么啊？追问更新除了type和xtype的后4列

声明：本网页内容为用户发布，旨在传播知识，不代表本网认同其观点，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。E-MAIL:11247931@qq.com