수원성
(강경수)
|
|
여러개 레코드 한번에 Insert 하기...
MySql
INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);
FireBird(Interbase)
INSERT INTO table1 (col1, col2)
SELECT 2, 'two ' FROM RDB$DATABASE UNION ALL
SELECT 4, 'four' FROM RDB$DATABASE UNION ALL
SELECT 5, 'five' FROM RDB$DATABASE;
Oracle
insert into pager (PAG_ID,PAG_PARENT,PAG_NAME,PAG_ACTIVE)
select 8000,0,'Multi 8000',1 from dual union all
select 8001,0,'Multi 8001',1 from dual
INSERT ALL
INTO mytable (column1, column2, column_n) VALUES (expr1, expr2, expr_n)
INTO mytable (column1, column2, column_n) VALUES (expr1, expr2, expr_n)
INTO mytable (column1, column2, column_n) VALUES (expr1, expr2, expr_n)
SELECT * FROM dual;
2017-04-27 오전 9:49:23
|
|
