mysql 插入更新多条数据的效率问题

http://topic.csdn.net/u/20110310/13/3279054f-5022-4fac-baa7-d194f5335ba0.html

http://www.rosoo.net/a/201103/11043.html

http://topic.csdn.net/u/20080921/18/718f167e-e030-439d-a206-b2dc3dc99a3f.html?1273378877

http://www.cnblogs.com/yahle/archive/2007/08/08/848060.html

http://www.karlrixon.co.uk/articles/sql/update-multiple-rows-with-different-values-and-a-single-sql-query/
http://stuporglue.org/update-multiple-rows-at-once-with-different-values-in-mysql/
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=69902

you can use this query:

UPDATE categories
SET display_order = 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)