在线等，新手求语句

Question

insert table2(id,a,b,c,r,s,t,x,y,z)
select id,a,b,c,'r','s','t','x','y','z' from table1 where 你的条件

Answer 1

insert table2(id,a,b,c,r,s,t,x,y,z) values((select id,a,b,c from table1 where id=1),'r','s','t','x','y','z') 

Answer 2

insert table2(id,a,b,c,r,s,t,x,y,z) values((select id,a,b,c from table1 where id=1),'r','s','t','x','y','z')