update student set `weight` = case `name` when 'lin' then 100 when 'yang' then 101 when 'sun' then 103 else 104 end where class_id = '2';
转载于:https://www.cnblogs.com/Mike-Feng/p/6133325.html
update student set `weight` = case `name` when 'lin' then 100 when 'yang' then 101 when 'sun' then 103 else 104 end where class_id = '2';
转载于:https://www.cnblogs.com/Mike-Feng/p/6133325.html