insert-name.sql « cpe-match « sql « dbstore - cvez - Unnamed repository; edit this file 'description' to name the repository.

about summary refs log tree commit diff

path: root/dbstore/sql/cpe-match/insert-name.sql

blob: adc99f436aa327b3eb131cabbf7161f70992f63d (plain)

INSERT INTO cpe_match_cpes(
  cpe_match_id,
  cpe_id,
  cpe22_uri
) VALUES (?, (SELECT cpe_id FROM cpes WHERE cpe23 = ?), ?);