1. 批量更新
update table_name set field_name = CASE id
WHEN id1 THEN field_value,
WHEN id1 THEN field_value
END
2.批量插入
insert into table_name (field1_name, field2_name) values(field1_value, field2_name) , (field1_value, field2_name)
原文：http://www.cnblogs.com/xshang/p/4619935.html