c*****t
发帖数: 1879 | 1 I am trying to implement foreign key query myself. That is, given
table S, and a set of columns (s1, .. sn) in S, check if all set of
values are in the table T and unique key columns (t1, ... t).
What's the most efficient query?
thx |
n********6
发帖数: 1511 | 2 Cannot fully understand your question.
How about using the join? |
c*****t
发帖数: 1879 | 3 Basically, manually check foreign key reference (rather than using
reference T(t1...tn)
【在 n********6 的大作中提到】
: Cannot fully understand your question.
: How about using the join?
|
B*****g
发帖数: 34098 | 4 why not just apply?
【在 c*****t 的大作中提到】
: Basically, manually check foreign key reference (rather than using
: reference T(t1...tn)
|
c*****t
发帖数: 1879 | 5 Because I am implementing it ...
【在 B*****g 的大作中提到】
: why not just apply?
|
j*****n
发帖数: 1781 | |
c*****t
发帖数: 1879 | 7 Right now my implementation was very stupidly simple. For each
record of A, I check if there is a referenced record in B. While
this is easy to code, I am wondering if there are faster approaches
for batch insertions.
【在 c*****t 的大作中提到】
: Because I am implementing it ...
|
