SQL_根据不同条件进行更新
时间:2022-03-14 00:36
update Students set chineseLevel = case when chinese < 60 then ‘D‘ when 60<=chinese and chinese <70 then ‘C‘ when 70<=chinese and chinese <80 then ‘B‘ when chinese >= 80 then ‘A‘ end
时间:2022-03-14 00:36
update Students set chineseLevel = case when chinese < 60 then ‘D‘ when 60<=chinese and chinese <70 then ‘C‘ when 70<=chinese and chinese <80 then ‘B‘ when chinese >= 80 then ‘A‘ end