mysql case when

最新推荐文章于 2024-02-01 14:36:11 发布

码丁农

最新推荐文章于 2024-02-01 14:36:11 发布

阅读量681

点赞数

分类专栏： MySQL SQL语句文章标签： mysql 虚拟机

本文链接：https://blog.csdn.net/dyzhen/article/details/6594376

版权

MySQL SQL语句专栏收录该内容

34 篇文章 0 订阅

订阅专栏

update T_Bypass_Net set isProtect = (case isProtect when 1 then 0 when 0 then 1 end), worker = (case isProtect when 1 then '' end) where ID = 2

update T_Bypass_NAC set empName = '非法IP', IP = '192.168.1.248', MAC = '00-0c-29-f8-c6-7b', Type = (case Type when 5 then 2 else Type end), beginTime = '2011-07-09 17:52:46', endTime = '2011-07-09 23:52:46', mode = 2 where Id = 93

SELECT DISTINCT NO_FILTRATE.empName, NO_FILTRATE.ComputerName , NO_FILTRATE.depName, NO_FILTRATE.OS, NO_FILTRATE.iState,
NO_FILTRATE.loginUserName, NO_FILTRATE.SetUpTime, NO_FILTRATE.IP, (CASE WHEN NO_FILTRATE.pcName = A.clientID THEN A.clientInfo ELSE NO_FILTRATE.MAC END), NO_FILTRATE.BackMess, NO_FILTRATE.clientState
FROM T_SC_UserManager AS NO_FILTRATE , T_SC_ClientIdentifier AS A
WHERE (CASE WHEN NO_FILTRATE.pcName = A.clientID THEN (NO_FILTRATE.pcName = A.clientID AND NO_FILTRATE.empName = 'czy-xp虚拟机') ELSE (NO_FILTRATE.empName = 'czy-xp虚拟机') END)