1.mysql: insert into tablename (column1,column2) values ('a','b'),('c','d');
2.oracle:insert into tablename (column1,column2) select 'a','b' from dual union select 'c','d' from dual;
3.mysql:
单字段,UPDATE categories
SET display_order = CASE id
WHEN 1 THEN 3
WHEN 2 THEN 4
WHEN 3 THEN 5
END
WHERE id IN (1,2,3),
多字段,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)