UPDATE t_agent_file SET rate1 = (
CASE publish_bat_no WHEN 'ea2d60b298944f5290f6f205d5c27480' THEN '2' WHEN 'ba579407bf29453d982aa2b74a0d93b5' THEN '1' WHEN 'e54aa6e1edbf4801b6856a1df505c049' THEN '3' ELSE rate1 END )
WHERE agent_id in (2,1,3)
这里有个问题:更新的顺序是按照主键的顺序的