指定字段赋值:
insert into a (tag, age) (select 'qq', 'ww' from dual)
全部字段按顺序赋值:
insert into a
select 'qq', 'ww' from dual
指定字段赋值:
insert into a (tag, age) (select 'qq', 'ww' from dual)
全部字段按顺序赋值:
insert into a
select 'qq', 'ww' from dual