UPDATE test SET sex_name=CASE sex WHEN 1 THEN '男' WHEN 2 THEN '女' ELSE '未填写' END WHERE Fid in (1,2,3,4) 运行前: 运行后: