mysql编写不停变更数据状态的sql,类似于点击某个按钮，点击开启，开启后点击关闭

update 表 set A = (case when A=满足一定的条件 then '111' else '222' end)

 

UPDATE third_party SET p_static = ( CASE WHEN p_static = 1 THEN 2 ELSE 1 END ) WHERE p_id = #{pId}