CREATE TEMPORARY TABLE stage_existing_spec(id BIGINT PRIMARY KEY,code VARCHAR(100),name VARCHAR(200),specification VARCHAR(255)) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; INSERT INTO stage_existing_spec VALUES('511','Q2100200','益生元西梅饮','350ml(35ml×10)'); INSERT INTO stage_existing_spec VALUES('518','Q2100205','蓝莓叶黄素DHA饮品','350ml(35ml×10)'); INSERT INTO stage_existing_spec VALUES('519','U2100337','人参葛根枳椇子玉米低聚肽饮品','400ml(50ml×8)'); INSERT INTO stage_existing_spec VALUES('610','81003766','质量保障防伪贴小号-圆25MM','圆25MM'); INSERT INTO stage_existing_spec VALUES('630','81003765','质量保障防伪贴大号-圆42MM','圆42MM'); INSERT INTO stage_existing_spec VALUES('714','61902914','黑加仑浓缩汁','黑加仑浓缩汁'); INSERT INTO stage_existing_spec VALUES('715','61902915','叶黄素酯','叶黄素酯'); INSERT INTO stage_existing_spec VALUES('717','61902916','Meso玉米黄质(3R,3''S) -二羟基-β-胡萝卜素','胡萝卜素'); INSERT INTO stage_existing_spec VALUES('721','61900766','枳椇子-统货','统货'); INSERT INTO stage_existing_spec VALUES('722','61901768','百合','一级'); INSERT INTO stage_existing_spec VALUES('746','61900897','维生素C-KG','KG'); INSERT INTO stage_existing_spec VALUES('761','61902906','白葡萄浓缩汁','白葡萄浓缩汁'); INSERT INTO stage_existing_spec VALUES('762','61902907','N-乙酰神经氨酸','N-乙酰神经氨酸'); INSERT INTO stage_existing_spec VALUES('764','61902909','磷脂酰丝氨酸','磷脂酰丝氨酸'); INSERT INTO stage_existing_spec VALUES('768','61902913','果胶','果胶'); INSERT INTO stage_existing_spec VALUES('791','74000431','黑果枸杞半成品-去柄','去柄'); INSERT INTO stage_existing_spec VALUES('799','74000432','黑果枸杞半成品-带柄','带柄'); INSERT INTO stage_existing_spec VALUES('801','81002900','袋泡茶饮滤膜PLA带火漆印-160mm','160mm'); INSERT INTO stage_existing_spec VALUES('802','81009468','黑枸杞袋泡茶复合膜','2克'); INSERT INTO stage_existing_spec VALUES('822','61900893','白芸豆提取物-KG','KG'); INSERT INTO stage_existing_spec VALUES('834','81009837','0.4MM厚PET胶盖','透明PET'); INSERT INTO stage_existing_spec VALUES('836','74000446','二级半成品-去柄(种植)','去柄(种植)'); INSERT INTO stage_existing_spec VALUES('838','62901032','重瓣红玫瑰花粉','KG'); INSERT INTO stage_existing_spec VALUES('851','81002988','纸箱(精制饮片中箱)','49.4cm*39.6cm*14cm'); INSERT INTO stage_existing_spec VALUES('852','81002989','垫板(精制饮片中箱)','48cm*38.2cm'); INSERT INTO stage_existing_spec VALUES('858','81004026','防伪溯源二维码标识(圆形)-直径3cm','直径3cm'); INSERT INTO stage_existing_spec VALUES('859','81004027','防伪溯源二维码标识(长方形)-3cm*2cm','3cm*2cm'); INSERT INTO stage_existing_spec VALUES('862','81011121','20罐小罐茶纸箱','58*22*28cm'); INSERT INTO stage_existing_spec VALUES('863','81011122','20罐小罐茶纸箱垫板','56*21cm'); INSERT INTO stage_existing_spec VALUES('879','61500004','85#特级血燕盏-散','散'); INSERT INTO stage_existing_spec VALUES('880','61500249','食用燕窝-白燕条/A2','白燕条/A2'); INSERT INTO stage_existing_spec VALUES('914','61500005','85#洞燕窝(配料)-燕盏','燕盏'); INSERT INTO stage_existing_spec VALUES('926','81010123','洞燕碗燕礼盒底托套装(10碗装)','10碗装'); INSERT INTO stage_existing_spec VALUES('933','62500064','顶级特选血燕盏85#-散','散'); INSERT INTO stage_existing_spec VALUES('936','81009924','燕窝封口膜','AL90/pe50'); INSERT INTO stage_existing_spec VALUES('937','81009925','846铝罐(燕窝碗)','846#外蓝内白'); INSERT INTO stage_existing_spec VALUES('938','61500013','白燕丝','散'); INSERT INTO stage_existing_spec VALUES('939','81009982','碗燕勺子卡盒','3碗装/6碗装'); INSERT INTO stage_existing_spec VALUES('940','81009981','洞燕碗燕礼盒底托套装','6碗装');