1 2 3 4 5
-- add cve INSERT INTO cves(item_id, cve_year, cve_num, assigner_id) VALUES ( ?, ?, ?, (SELECT assigner_id FROM assigners WHERE assigner = ?) );