Multi-row insert syntax examples for various DBMS

mulit-row-insert.sql

-- Oracle flavor
insert all
   into t (col1, col2, col3) values ('val1_1', 'val1_2', 'val1_3')
   into t (col1, col2, col3) values ('val2_1', 'val2_2', 'val2_3')
   into t (col1, col2, col3) values ('val3_1', 'val3_2', 'val3_3')
   .
   .
   .
select 1 from dual;

-- MySQL SQL Server flavor
insert into t (col1, col2, col3) values
    ('val1_1', 'val1_2', 'val1_3'),
    ('val2_1', 'val2_2', 'val2_3'),
    ('val3_1', 'val3_2', 'val3_3'),
    .
    .
    .
;