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)