UPDATE table
SET total = CASE WHEN total = '1' THEN total- 1 ELSE total = '2' END
WHERE id = 17
UPDATE table
SET total = CASE WHEN total = '1' THEN total- 1 ELSE total = '2' END
WHERE id = 17
转载于:https://www.cnblogs.com/huixuexidezhu/p/8553556.html