-- Delete products produced by a manufacturer.
-- The manufacturer id is specified as a
-- dynamic parameter for use with JDBC.
-- A question mark replaces the manufacturer
-- id literal in delete-by-manufacturer-id.sql.
--
DELETE FROM product
WHERE manufacturer_id = ?
