insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(1,'电子产品',0,'' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(2,'收音机',1,'1,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(4,'日用品',0,'' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(5,'纸',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(6,'抽纸',5,'4,5,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(7,'食品',0,'' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(8,'米',95,'7,95,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(9,'书籍',0,'' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(10,'计算机',9,'9,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(11,'移动开发',10,'9,10,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(12,'无芯卷纸',5,'4,5,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(13,'饮料',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(14,'奶粉',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(15,'架构设计',10,'9,10,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(16,'操作系统',10,'9,10,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(17,'Web',10,'9,10,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(18,'设计模式',10,'9,10,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(19,'粉',95,'7,95,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(20,'游戏开发',10,'9,10,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(21,'.NET',10,'9,10,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(22,'软件工程',10,'9,10,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(23,'性能优化',10,'9,10,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(24,'C/C++',10,'9,10,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(25,'耳机',1,'1,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(26,'手机',1,'1,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(27,'计算机基础',10,'9,10,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(28,'网络',10,'9,10,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(29,'GO语言',10,'9,10,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(30,'JavaScript',10,'9,10,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(31,'方包纸',5,'4,5,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(32,'Python',10,'9,10,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(33,'SQL',10,'9,10,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(34,'算法',10,'9,10,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(35,'Java',10,'9,10,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(36,'界面设计',10,'9,10,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(37,'3DSMAX',10,'9,10,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(38,'烘炒类',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(39,'糖水型罐头',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(40,'油炸类',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(41,'灌肠类',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(42,'花生',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(43,'蒸煮大豆蛋白制品',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(44,'膨化食品',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(47,'流质糖果',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(48,'烘烤类糕点',70,'7,70,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(49,'其他型硬质糖果',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(50,'油炸类糕点',70,'7,70,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(51,'牙线',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(53,'手机配件',1,'1,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(58,'威化饼',126,'7,126,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(59,'巧克力',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(60,'蚊香',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(61,'牛肉',161,'7,161,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(62,'手帕纸',5,'4,5,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(63,'盒饭',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(64,'方便面',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(65,'电脑入门',10,'9,10,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(66,'鼠标',1,'1,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(67,'USB集线器',1,'1,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(68,'调味酱',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(69,'音箱',1,'1,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(70,'糕点',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(71,'冷加工糕点',70,'7,70,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(73,'药品',0,'' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(74,'水果饮料',13,'7,13,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(75,'鸡肉',161,'7,161,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(76,'酸奶',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(77,'风味熟制水产品',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(78,'硫磺皂',109,'4,109,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(79,'汽水',13,'7,13,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(80,'发酵饼干',126,'7,126,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(81,'卤蛋',202,'7,202,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(82,'果糕类',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(83,'坚果制品',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(84,'月饼',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(85,'花露水',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(86,'麦克风',1,'1,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(87,'风油精',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(88,'沐浴露',109,'4,109,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(89,'服装鞋帽',0,'' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(90,'长袖',89,'89,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(91,'短袖',89,'89,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(92,'长裤',89,'89,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(93,'底裤',89,'89,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(94,'榨菜萝卜干',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(95,'主食',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(96,'面条',95,'7,95,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(97,'包包',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(98,'酒',13,'7,13,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(99,'凉茶饮料',13,'7,13,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(100,'杯子',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(101,'电池',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(102,'其他植物饮料',13,'7,13,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(103,'雪糕',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(104,'打火机',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(105,'短裤',89,'89,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(106,'吐司面包',70,'7,70,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(107,'棉签',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(108,'茶饮品',13,'7,13,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(109,'浴室',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(110,'沐浴球',109,'4,109,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(111,'全脂灭菌纯牛乳',13,'7,13,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(112,'植物蛋白饮料',13,'7,13,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(113,'沙琪玛',70,'7,70,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(114,'洁厕灵',109,'4,109,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(115,'凉果类',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(116,'矿泉水',13,'7,13,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(117,'腐乳',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(118,'压缩饼干',126,'7,126,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(119,'雨伞',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(121,'酱卤肉制品',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(122,'蜜饯类',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(123,'起酥面包',70,'7,70,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(124,'注芯蛋类芯饼',70,'7,70,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(125,'手串',89,'89,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(126,'饼干',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(127,'夹心饼干',126,'7,126,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(128,'键盘',1,'1,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(129,'文具',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(130,'厨房调料',0,'' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(131,'湿巾',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(132,'鞋子',89,'89,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(133,'毛巾',89,'89,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(134,'便当盒',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(138,'粘钩',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(139,'能量饮料',13,'7,13,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(140,'包子',95,'7,95,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(141,'水果干制品',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(142,'咖喱饮料',13,'7,13,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(143,'香皂',109,'4,109,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(144,'垃圾袋',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(145,'指甲钳',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(146,'洗发露',109,'4,109,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(147,'床上用品',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(148,'枕头',147,'4,147,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(149,'蛋卷',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(150,'麦芽汁发酵饮品',13,'7,13,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(151,'果冻',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(152,'猪肉',161,'7,161,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(153,'风味饮料',13,'7,13,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(154,'热加工糕点',70,'7,70,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(155,'韧性饼干',126,'7,126,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(156,'粘鼠板',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(157,'肉类罐头',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(158,'充电宝',1,'1,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(159,'电煮锅',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(160,'餐具',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(161,'肉类',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(162,'奶茶饮料',13,'7,13,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(163,'84消毒液',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(164,'汉堡',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(165,'自热食品',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(166,'汤圆',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(167,'调味面制品',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(168,'毛巾',109,'4,109,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(169,'洗衣皂',109,'4,109,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(170,'护肤品',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(171,'配制型含乳饮料',13,'7,13,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(172,'鸭肉',161,'7,161,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(173,'地图',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(174,'蔬菜制品',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(175,'即食魔芋凝胶食品',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(176,'熏煮香肠',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(177,'酥性饼干',126,'7,126,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(178,'曲奇饼干',126,'7,126,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(179,'固体饮料',13,'7,13,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(180,'方便食品',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(181,'内存',1,'1,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(182,'CPU',1,'1,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(183,'主板',1,'1,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(184,'主板诊断卡',1,'1,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(185,'电源',1,'1,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(186,'注心饼干',126,'7,126,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(187,'牙膏',109,'4,109,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(188,'风扇',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(189,'厨房用具',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(190,'外国文学',9,'9,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(191,'腌腊肉制品',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(192,'酱腌菜',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(193,'云吞',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(194,'祭拜香烛',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(195,'水果',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(196,'葡萄',195,'7,195,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(197,'钥匙扣',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(198,'西瓜',195,'7,195,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(199,'青菜',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(200,'书签',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(201,'手机支架',4,'4,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(202,'蛋类',7,'7,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(203,'咸蛋',202,'7,202,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(204,'鸡蛋',202,'7,202,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(205,'松花蛋',202,'7,202,' )
insert into categories(CategoryId,CategoryName,ParentID,CategoryPath) values(206,'空气清新剂',4,'4,' )