insert
插入方式:
- 指定插入数据
insert into Z(a,b,c)values(1,2,3); - 指定插入数据
insert into Z(a,b,c) select 1,2,3 from dual; - 指定插入A表某一行数据
insert from Z(a,b,c) select d,e,f from A where id = 1;
插入方式:
insert into Z(a,b,c)values(1,2,3);insert into Z(a,b,c) select 1,2,3 from dual;insert from Z(a,b,c) select d,e,f from A where id = 1;