insert
into
dest
-
tablename(a, b, c)
select
d,e,f
from
source
-
tablename;
还可以这样
insert into dest
-
tablename(a, b, c)
select
'
1',e,f from source-tablename;