update table
set
djyzmdm=null,
djyzmsj=null,
DLCS= case when DLCS is null then 1 else DLCS+1 end
where djyzmsj=‘xxx’
2、
update table
set
datetime
= 1434567890,
status
= case id
when 12 Then 1 when 13 Then 2 end
where id
in (12,13,14)
update table
set
datetime
= 1434567890,
status
= case when id =12 Then 1 when id=13 Then 2 end
where id
in (12,13,14)