Search This Blog

2017/02/07

Insert two rows into db with one sql

MySQl
insert into table(columns...)values(value1...),(value2...),(value3...)
add more rows by ,(value...)
Oracle
insert all
into table(columns...)values(value1...)
into table(columns...)values(value2...)
select 1 from dual

No comments :

Post a Comment