- UPDATE `表名`
- SET `字段` = CASE id
- WHEN 1 THEN 3
- WHEN 2 THEN 4
- WHEN 3 THEN 5
- END,
- title = CASE id
- WHEN 1 THEN ‘New Title 1‘
- WHEN 2 THEN ‘New Title 2‘
- WHEN 3 THEN ‘New Title 3‘
- END
- WHERE id IN (1,2,3)
mysql 批量更新语句
原文：http://www.cnblogs.com/zo11o/p/7101966.html
