case when条件查询 代码 简单的修改 update class set num = ( case when Id = 1 then 200 when Id = 2 then 300 END); 简单的查询 select * from class where Id = ( case when num = 200 then Id end)