1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
| 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碗装');
|
|