diff options
Diffstat (limited to 'dbstore/sql/cpe-match')
| -rw-r--r-- | dbstore/sql/cpe-match/insert-name.sql | 9 |
1 files changed, 4 insertions, 5 deletions
diff --git a/dbstore/sql/cpe-match/insert-name.sql b/dbstore/sql/cpe-match/insert-name.sql index adc99f4..ebdb638 100644 --- a/dbstore/sql/cpe-match/insert-name.sql +++ b/dbstore/sql/cpe-match/insert-name.sql @@ -1,5 +1,4 @@ -INSERT INTO cpe_match_cpes( - cpe_match_id, - cpe_id, - cpe22_uri -) VALUES (?, (SELECT cpe_id FROM cpes WHERE cpe23 = ?), ?); +INSERT INTO cpe_match_cpes(cpe_match_id, cpe_id, cpe22_uri) + SELECT ?, cpe_id, ? + FROM cpes + WHERE cpe23 = ?; |