Mysql update case

UPDATE  table
SET     total = CASE WHEN total = '1' THEN total- 1 ELSE total = '2' END
WHERE   id = 17

  

posted on 2018-03-13 09:20  会学习的猪  阅读(404)  评论(0)    收藏  举报

导航