1、批量插入

INSERT INTO table (field1,field2,field3)

VALUES ('a',"b","c"), ('a',"b","c"),('a',"b","c")

2、批量更新

UPDATE T_Free_Orders_Record 

SET sendtime = 

CASE

WHEN id = 1 THEN '2016-07-14 15:18:21'

WHEN id = 2 THEN '2016-07-14 21:32:08' 

WHEN id = 3 THEN '2016-07-15 12:35:21' 

WHEN id = 4 THEN '2016-07-15 20:47:24' 

END

WHERE id IN (1,2,3,4)