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
