update `badges` set `cat_point` =
CASE WHEN level >= 1 THEN POW(2, `level` - 1) ELSE 0 END
where name not like '%Steam%';
if level >=1 :
cat_point = POW(2, `level` - 1)
else:
cat_point = 0
标签：case,level,point,when,cat,else From： https://www.cnblogs.com/zhanchenjin/p/17781337.html