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