UPDATE person SET name = CASE id WHEN 1 THEN 'Jim' WHEN 2 THEN 'Mike' WHEN 3 THEN 'Precious' END, sex = CASE id WHEN 1 THEN 'female' WHEN 2 THEN 'male' WHEN 3 THEN 'male' ENDWHERe id IN (1,2,3)
UPDATE person SET name = CASE id WHEN 1 THEN 'Jim' WHEN 2 THEN 'Mike' WHEN 3 THEN 'Precious' END, sex = CASE id WHEN 1 THEN 'female' WHEN 2 THEN 'male' WHEN 3 THEN 'male' ENDWHERe id IN (1,2,3)
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
