atec2000的专栏

原创 sql的case语句

update: update vuchnl_content set is_alerted=(   case is_alerted   when 0 then 1   when 1 then 2   when 2 then 3   else is_alerted   end ) where vuchnl_content_id in (1,2);