mysql case when

来源：互联网发布：淘宝卖家猝死2016 编辑：程序博客网时间：2024/06/05 17:27

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)