sql 批量更新语句，可用于大量修改

UPDATE tableName  SET `_a` = CASE  

 WHEN `_id` = "1"  and `_b`="2" THEN "这是说明将id为1的a的字段改成此字段"

 WHEN `_id` = "2"  and `_b`="2"  THEN "这是说明将id为2的a的字段改成此字段"

 WHEN `_id` = "3"  and `_b`="2"  THEN "这是说明将id为3的a的字段改成此字段"

 END WHERE `_id` IN ("1","2","3")   and `_b`="2" ;

b字段作为加强控制，可有可无