Mysql语句的批量操作[修改]

 1 UPDATE `cla_info` SET 
 2 
 3 `comment` =  CASE 
 4 WHEN (`score` >= 95) THEN 'A' 
 5 WHEN (`score` < 95 AND `score` >= 80) THEN 'B' 
 6 WHEN (`score` < 80 AND `score` >= 60) THEN 'C' 
 7 WHEN (`score` < 60) THEN 'D' 
 8 END, 
 9 
10 `collect` = CASE 
11 WHEN (`score` >= 95) THEN 'X' 
12 WHEN (`score` < 95 AND `score` >= 60) THEN 'Y'
13 WHEN (`score` < 60) THEN 'Z' 
14 END 
15 
16 WHERE `id` > 2
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/intval/p/3581930.html