Cacher is the code snippet organizer for pro developers

 CREATE TEMPORARY TABLE IF NOT EXISTS tmpBOMItems (
    id int,
    BOMID int,
    BOMType char(1),
    BOMTypeID int
  );

  DELETE FROM tmpBOMItems;
  
  -- Do stuff
  
  DROP TEMPORARY TABLE IF EXISTS tmpBOMItems;