插入多个子查询作为值 [英] Insert into with multiple subqueries as values
本文介绍了插入多个子查询作为值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
假设我必须插入一个有很多 fk 的表,只是为了在下面解释错误的陈述:
Lets suppose I've to insert into a table with many fk, just to explain here below the wrong statement:
insert into mytable
values
(
somevalue
,somevalue
,select id from othertable1 where ...condition
,select id from othertable2 where ...condition
,select id from othertable3 where ...condition
)
所以基本上要插入的值来自不同的子查询,是否有可能实现这样的行为?
so basically values to insert comes from different subqueries, is it possible to achieve such a behavior ?
推荐答案
insert into mytable (columns)
select somevalue, somevalue, a.id, b.id, c.id
from
othertable1 a
cross join othertable2 b
cross join othertable3 c
where
a ... condition
b ... condition
c ... condition
这篇关于插入多个子查询作为值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文