Question

SQL insert 中带 select

insert into t1(a,b,c,d)
values(a,(select b from t2 where 1=1),(select b from t2 where 1=1),(select b from t2 where 1=1),(select b from t2 where 1=1))

有没有更简单的方法 where 查询的条件一样

Answer 1

insert into t1(a,b,c,d)
select 'a',b,b,b from t2
因为你写的都是b，喊祥所洞物以纳渗液我也就都写得b。

追问

就这样的格式写？？？