· 7 years ago · Jan 11, 2019, 05:36 AM
1CREATE TEMPORARY TABLE IF NOT EXISTS tmpBOMItems (
2 id int,
3 BOMID int,
4 BOMType char(1),
5 BOMTypeID int
6 );
7
8 DELETE FROM tmpBOMItems;
9
10 -- Do stuff
11
12 DROP TEMPORARY TABLE IF EXISTS tmpBOMItems;