mysql,oracle批量插入，更新

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)