Update 表 set grade=case when (chinese+math)>120 then "合格" when (chinese+math)>160 then "良好" when (chinese+math)>180 then "优秀" end
https://bbs.fanruan.com/wenda/question/129237.html
这不都给你回答了嘛