insert into tableName
(x1,x2,x3,x4,x5,x6)
select x1,
x2,
x3,
x4,
' 你好',
sysdate
from tableName1 t
where t.x1= 'x1_ss'
insert into tableName
(x1,x2,x3,x4,x5,x6)
select x1,
x2,
x3,
x4,
' 你好',
sysdate
from tableName1 t
where t.x1= 'x1_ss'