INSERT INTO tb_areas_city (id, cityid, city, provinceid) VALUES (1,'110100','市辖区','110000'),(2,'110200','县','110000'),(3,'120100','市辖区','120000'),(4,'120200','县','120000'),(5,'130100','石家庄市','130000'),(6,'130200','唐山市','130000'),(7,'130300','秦皇岛市','130000'),(8,'130400','邯郸市','130000'),(9,'130500','邢台市','130000'),(10,'130600','保定市','130000'),(11,'130700','张家口市','130000'),(12,'130800','承德市','130000'),(13,'130900','沧州市','130000'),(14,'131000','廊坊市','130000'),(15,'131100','衡水市','130000'),(16,'140100','太原市','140000'),(17,'140200','大同市','140000'),(18,'140300','阳泉市','140000'),(19,'140400','长治市','140000'),(20,'140500','晋城市','140000'),(21,'140600','朔州市','140000'),(22,'140700','晋中市','140000'),(23,'140800','运城市','140000'),(24,'140900','忻州市','140000'),(25,'141000','临汾市','140000'),(26,'141100','吕梁市','140000'),(27,'150100','呼和浩特市','150000'),(28,'150200','包头市','150000'),(29,'150300','乌海市','150000'),(30,'150400','赤峰市','150000'),(31,'150500','通辽市','150000'),(32,'150600','鄂尔多斯市','150000'),(33,'150700','呼伦贝尔市','150000'),(34,'150800','巴彦淖尔市','150000'),(35,'150900','乌兰察布市','150000'),(36,'152200','兴安盟','150000'),(37,'152500','锡林郭勒盟','150000'),(38,'152900','阿拉善盟','150000'),(39,'210100','沈阳市','210000'),(40,'210200','大连市','210000'),(41,'210300','鞍山市','210000'),(42,'210400','抚顺市','210000'),(43,'210500','本溪市','210000'),(44,'210600','丹东市','210000'),(45,'210700','锦州市','210000'),(46,'210800','营口市','210000'),(47,'210900','阜新市','210000'),(48,'211000','辽阳市','210000'),(49,'211100','盘锦市','210000'),(50,'211200','铁岭市','210000'),(51,'211300','朝阳市','210000'),(52,'211400','葫芦岛市','210000'),(53,'220100','长春市','220000'),(54,'220200','吉林市','220000'),(55,'220300','四平市','220000'),(56,'220400','辽源市','220000'),(57,'220500','通化市','220000'),(58,'220600','白山市','220000'),(59,'220700','松原市','220000'),(60,'220800','白城市','220000'),(61,'222400','延边朝鲜族自治州','220000'),(62,'230100','哈尔滨市','230000'),(63,'230200','齐齐哈尔市','230000'),(64,'230300','鸡西市','230000'),(65,'230400','鹤岗市','230000'),(66,'230500','双鸭山市','230000'),(67,'230600','大庆市','230000'),(68,'230700','伊春市','230000'),(69,'230800','佳木斯市','230000'),(70,'230900','七台河市','230000'),(71,'231000','牡丹江市','230000'),(72,'231100','黑河市','230000'),(73,'231200','绥化市','230000'),(74,'232700','大兴安岭地区','230000'),(75,'310100','市辖区','310000'),(76,'310200','县','310000'),(77,'320100','南京市','320000'),(78,'320200','无锡市','320000'),(79,'320300','徐州市','320000'),(80,'320400','常州市','320000'),(81,'320500','苏州市','320000'),(82,'320600','南通市','320000'),(83,'320700','连云港市','320000'),(84,'320800','淮安市','320000'),(85,'320900','盐城市','320000'),(86,'321000','扬州市','320000'),(87,'321100','镇江市','320000'),(88,'321200','泰州市','320000'),(89,'321300','宿迁市','320000'),(90,'330100','杭州市','330000'),(91,'330200','宁波市','330000'),(92,'330300','温州市','330000'),(93,'330400','嘉兴市','330000'),(94,'330500','湖州市','330000'),(95,'330600','绍兴市','330000'),(96,'330700','金华市','330000'),(97,'330800','衢州市','330000'),(98,'330900','舟山市','330000'),(99,'331000','台州市','330000'),(100,'331100','丽水市','330000'),(101,'340100','合肥市','340000'),(102,'340200','芜湖市','340000'),(103,'340300','蚌埠市','340000'),(104,'340400','淮南市','340000'),(105,'340500','马鞍山市','340000'),(106,'340600','淮北市','340000'),(107,'340700','铜陵市','340000'),(108,'340800','安庆市','340000'),(109,'341000','黄山市','340000'),(110,'341100','滁州市','340000'),(111,'341200','阜阳市','340000'),(112,'341300','宿州市','340000'),(113,'341400','巢湖市','340000'),(114,'341500','六安市','340000'),(115,'341600','亳州市','340000'),(116,'341700','池州市','340000'),(117,'341800','宣城市','340000'),(118,'350100','福州市','350000'),(119,'350200','厦门市','350000'),(120,'350300','莆田市','350000'),(121,'350400','三明市','350000'),(122,'350500','泉州市','350000'),(123,'350600','漳州市','350000'),(124,'350700','南平市','350000'),(125,'350800','龙岩市','350000'),(126,'350900','宁德市','350000'),(127,'360100','南昌市','360000'),(128,'360200','景德镇市','360000'),(129,'360300','萍乡市','360000'),(130,'360400','九江市','360000'),(131,'360500','新余市','360000'),(132,'360600','鹰潭市','360000'),(133,'360700','赣州市','360000'),(134,'360800','吉安市','360000'),(135,'360900','宜春市','360000'),(136,'361000','抚州市','360000'),(137,'361100','上饶市','360000'),(138,'370100','济南市','370000'),(139,'370200','青岛市','370000'),(140,'370300','淄博市','370000'),(141,'370400','枣庄市','370000'),(142,'370500','东营市','370000'),(143,'370600','烟台市','370000'),(144,'370700','潍坊市','370000'),(145,'370800','济宁市','370000'),(146,'370900','泰安市','370000'),(147,'371000','威海市','370000'),(148,'371100','日照市','370000'),(149,'371200','莱芜市','370000'),(150,'371300','临沂市','370000'),(151,'371400','德州市','370000'),(152,'371500','聊城市','370000'),(153,'371600','滨州市','370000'),(154,'371700','荷泽市','370000'),(155,'410100','郑州市','410000'),(156,'410200','开封市','410000'),(157,'410300','洛阳市','410000'),(158,'410400','平顶山市','410000'),(159,'410500','安阳市','410000'),(160,'410600','鹤壁市','410000'),(161,'410700','新乡市','410000'),(162,'410800','焦作市','410000'),(163,'410900','濮阳市','410000'),(164,'411000','许昌市','410000'),(165,'411100','漯河市','410000'),(166,'411200','三门峡市','410000'),(167,'411300','南阳市','410000'),(168,'411400','商丘市','410000'),(169,'411500','信阳市','410000'),(170,'411600','周口市','410000'),(171,'411700','驻马店市','410000'),(172,'420100','武汉市','420000'),(173,'420200','黄石市','420000'),(174,'420300','十堰市','420000'),(175,'420500','宜昌市','420000'),(176,'420600','襄樊市','420000'),(177,'420700','鄂州市','420000'),(178,'420800','荆门市','420000'),(179,'420900','孝感市','420000'),(180,'421000','荆州市','420000'),(181,'421100','黄冈市','420000'),(182,'421200','咸宁市','420000'),(183,'421300','随州市','420000'),(184,'422800','恩施土家族苗族自治州','420000'),(185,'429000','省直辖行政单位','420000'),(186,'430100','长沙市','430000'),(187,'430200','株洲市','430000'),(188,'430300','湘潭市','430000'),(189,'430400','衡阳市','430000'),(190,'430500','邵阳市','430000'),(191,'430600','岳阳市','430000'),(192,'430700','常德市','430000'),(193,'430800','张家界市','430000'),(194,'430900','益阳市','430000'),(195,'431000','郴州市','430000'),(196,'431100','永州市','430000'),(197,'431200','怀化市','430000'),(198,'431300','娄底市','430000'),(199,'433100','湘西土家族苗族自治州','430000'),(200,'440100','广州市','440000'),(201,'440200','韶关市','440000'),(202,'440300','深圳市','440000'),(203,'440400','珠海市','440000'),(204,'440500','汕头市','440000'),(205,'440600','佛山市','440000'),(206,'440700','江门市','440000'),(207,'440800','湛江市','440000'),(208,'440900','茂名市','440000'),(209,'441200','肇庆市','440000'),(210,'441300','惠州市','440000'),(211,'441400','梅州市','440000'),(212,'441500','汕尾市','440000'),(213,'441600','河源市','440000'),(214,'441700','阳江市','440000'),(215,'441800','清远市','440000'),(216,'441900','东莞市','440000'),(217,'442000','中山市','440000'),(218,'445100','潮州市','440000'),(219,'445200','揭阳市','440000'),(220,'445300','云浮市','440000'),(221,'450100','南宁市','450000'),(222,'450200','柳州市','450000'),(223,'450300','桂林市','450000'),(224,'450400','梧州市','450000'),(225,'450500','北海市','450000'),(226,'450600','防城港市','450000'),(227,'450700','钦州市','450000'),(228,'450800','贵港市','450000'),(229,'450900','玉林市','450000'),(230,'451000','百色市','450000'),(231,'451100','贺州市','450000'),(232,'451200','河池市','450000'),(233,'451300','来宾市','450000'),(234,'451400','崇左市','450000'),(235,'460100','海口市','460000'),(236,'460200','三亚市','460000'),(237,'469000','省直辖县级行政单位','460000'),(238,'500100','市辖区','500000'),(239,'500200','县','500000'),(240,'500300','市','500000'),(241,'510100','成都市','510000'),(242,'510300','自贡市','510000'),(243,'510400','攀枝花市','510000'),(244,'510500','泸州市','510000'),(245,'510600','德阳市','510000'),(246,'510700','绵阳市','510000'),(247,'510800','广元市','510000'),(248,'510900','遂宁市','510000'),(249,'511000','内江市','510000'),(250,'511100','乐山市','510000'),(251,'511300','南充市','510000'),(252,'511400','眉山市','510000'),(253,'511500','宜宾市','510000'),(254,'511600','广安市','510000'),(255,'511700','达州市','510000'),(256,'511800','雅安市','510000'),(257,'511900','巴中市','510000'),(258,'512000','资阳市','510000'),(259,'513200','阿坝藏族羌族自治州','510000'),(260,'513300','甘孜藏族自治州','510000'),(261,'513400','凉山彝族自治州','510000'),(262,'520100','贵阳市','520000'),(263,'520200','六盘水市','520000'),(264,'520300','遵义市','520000'),(265,'520400','安顺市','520000'),(266,'522200','铜仁地区','520000'),(267,'522300','黔西南布依族苗族自治州','520000'),(268,'522400','毕节地区','520000'),(269,'522600','黔东南苗族侗族自治州','520000'),(270,'522700','黔南布依族苗族自治州','520000'),(271,'530100','昆明市','530000'),(272,'530300','曲靖市','530000'),(273,'530400','玉溪市','530000'),(274,'530500','保山市','530000'),(275,'530600','昭通市','530000'),(276,'530700','丽江市','530000'),(277,'530800','思茅市','530000'),(278,'530900','临沧市','530000'),(279,'532300','楚雄彝族自治州','530000'),(280,'532500','红河哈尼族彝族自治州','530000'),(281,'532600','文山壮族苗族自治州','530000'),(282,'532800','西双版纳傣族自治州','530000'),(283,'532900','大理白族自治州','530000'),(284,'533100','德宏傣族景颇族自治州','530000'),(285,'533300','怒江傈僳族自治州','530000'),(286,'533400','迪庆藏族自治州','530000'),(287,'540100','拉萨市','540000'),(288,'542100','昌都地区','540000'),(289,'542200','山南地区','540000'),(290,'542300','日喀则地区','540000'),(291,'542400','那曲地区','540000'),(292,'542500','阿里地区','540000'),(293,'542600','林芝地区','540000'),(294,'610100','西安市','610000'),(295,'610200','铜川市','610000'),(296,'610300','宝鸡市','610000'),(297,'610400','咸阳市','610000'),(298,'610500','渭南市','610000'),(299,'610600','延安市','610000'),(300,'610700','汉中市','610000'),(301,'610800','榆林市','610000'),(302,'610900','安康市','610000'),(303,'611000','商洛市','610000'),(304,'620100','兰州市','620000'),(305,'620200','嘉峪关市','620000'),(306,'620300','金昌市','620000'),(307,'620400','白银市','620000'),(308,'620500','天水市','620000'),(309,'620600','武威市','620000'),(310,'620700','张掖市','620000'),(311,'620800','平凉市','620000'),(312,'620900','酒泉市','620000'),(313,'621000','庆阳市','620000'),(314,'621100','定西市','620000'),(315,'621200','陇南市','620000'),(316,'622900','临夏回族自治州','620000'),(317,'623000','甘南藏族自治州','620000'),(318,'630100','西宁市','630000'),(319,'632100','海东地区','630000'),(320,'632200','海北藏族自治州','630000'),(321,'632300','黄南藏族自治州','630000'),(322,'632500','海南藏族自治州','630000'),(323,'632600','果洛藏族自治州','630000'),(324,'632700','玉树藏族自治州','630000'),(325,'632800','海西蒙古族藏族自治州','630000'),(326,'640100','银川市','640000'),(327,'640200','石嘴山市','640000'),(328,'640300','吴忠市','640000'),(329,'640400','固原市','640000'),(330,'640500','中卫市','640000'),(331,'650100','乌鲁木齐市','650000'),(332,'650200','克拉玛依市','650000'),(333,'652100','吐鲁番地区','650000'),(334,'652200','哈密地区','650000'),(335,'652300','昌吉回族自治州','650000'),(336,'652700','博尔塔拉蒙古自治州','650000'),(337,'652800','巴音郭楞蒙古自治州','650000'),(338,'652900','阿克苏地区','650000'),(339,'653000','克孜勒苏柯尔克孜自治州','650000'),(340,'653100','喀什地区','650000'),(341,'653200','和田地区','650000'),(342,'654000','伊犁哈萨克自治州','650000'),(343,'654200','塔城地区','650000'),(344,'654300','阿勒泰地区','650000'),(345,'659000','省直辖行政单位','650000');

INSERT INTO tb_areas_provinces (id, provinceid, province) VALUES (1,'110000','北京市'),(2,'120000','天津市'),(3,'130000','河北省'),(4,'140000','山西省'),(5,'150000','内蒙古自治区'),(6,'210000','辽宁省'),(7,'220000','吉林省'),(8,'230000','黑龙江省'),(9,'310000','上海市'),(10,'320000','江苏省'),(11,'330000','浙江省'),(12,'340000','安徽省'),(13,'350000','福建省'),(14,'360000','江西省'),(15,'370000','山东省'),(16,'410000','河南省'),(17,'420000','湖北省'),(18,'430000','湖南省'),(19,'440000','广东省'),(20,'450000','广西壮族自治区'),(21,'460000','海南省'),(22,'500000','重庆市'),(23,'510000','四川省'),(24,'520000','贵州省'),(25,'530000','云南省'),(26,'540000','西藏自治区'),(27,'610000','陕西省'),(28,'620000','甘肃省'),(29,'630000','青海省'),(30,'640000','宁夏回族自治区'),(31,'650000','新疆维吾尔自治区'),(32,'710000','台湾省'),(33,'810000','香港特别行政区'),(34,'820000','澳门特别行');

INSERT INTO tb_areas_region (id, areaid, area, cityid) VALUES (1,'110101','东城','110100'),(2,'110102','西城区','110100'),(3,'110103','崇文区','110100'),(4,'110104','宣武区','110100'),(5,'110105','朝阳区','110100'),(6,'110106','丰台区','110100'),(7,'110107','石景山区','110100'),(8,'110108','海淀区','110100'),(9,'110109','门头沟区','110100'),(10,'110111','房山区','110100'),(11,'110112','通州区','110100'),(12,'110113','顺义区','110100'),(13,'110114','昌平区','110100'),(14,'110115','大兴区','110100'),(15,'110116','怀柔区','110100'),(16,'110117','平谷区','110100'),(17,'110228','密云县','110200'),(18,'110229','延庆县','110200'),(19,'120101','和平区','120100'),(20,'120102','河东区','120100'),(21,'120103','河西区','120100'),(22,'120104','南开区','120100'),(23,'120105','河北区','120100'),(24,'120106','红桥区','120100'),(25,'120107','塘沽区','120100'),(26,'120108','汉沽区','120100'),(27,'120109','大港区','120100'),(28,'120110','东丽区','120100'),(29,'120111','西青区','120100'),(30,'120112','津南区','120100'),(31,'120113','北辰区','120100'),(32,'120114','武清区','120100'),(33,'120115','宝坻区','120100'),(34,'120221','宁河县','120200'),(35,'120223','静海县','120200'),(36,'120225','蓟　县','120200'),(37,'130101','市辖区','130100'),(38,'130102','长安区','130100'),(39,'130103','桥东区','130100'),(40,'130104','桥西区','130100'),(41,'130105','新华区','130100'),(42,'130107','井陉矿区','130100'),(43,'130108','裕华区','130100'),(44,'130121','井陉县','130100'),(45,'130123','正定县','130100'),(46,'130124','栾城县','130100'),(47,'130125','行唐县','130100'),(48,'130126','灵寿县','130100'),(49,'130127','高邑县','130100'),(50,'130128','深泽县','130100'),(51,'130129','赞皇县','130100'),(52,'130130','无极县','130100'),(53,'130131','平山县','130100'),(54,'130132','元氏县','130100'),(55,'130133','赵　县','130100'),(56,'130181','辛集市','130100'),(57,'130182','藁城市','130100'),(58,'130183','晋州市','130100'),(59,'130184','新乐市','130100'),(60,'130185','鹿泉市','130100'),(61,'130201','市辖区','130200'),(62,'130202','路南区','130200'),(63,'130203','路北区','130200'),(64,'130204','古冶区','130200'),(65,'130205','开平区','130200'),(66,'130207','丰南区','130200'),(67,'130208','丰润区','130200'),(68,'130223','滦　县','130200'),(69,'130224','滦南县','130200'),(70,'130225','乐亭县','130200'),(71,'130227','迁西县','130200'),(72,'130229','玉田县','130200'),(73,'130230','唐海县','130200'),(74,'130281','遵化市','130200'),(75,'130283','迁安市','130200'),(76,'130301','市辖区','130300'),(77,'130302','海港区','130300'),(78,'130303','山海关区','130300'),(79,'130304','北戴河区','130300'),(80,'130321','青龙满族自治县','130300'),(81,'130322','昌黎县','130300'),(82,'130323','抚宁县','130300'),(83,'130324','卢龙县','130300'),(84,'130401','市辖区','130400'),(85,'130402','邯山区','130400'),(86,'130403','丛台区','130400'),(87,'130404','复兴区','130400'),(88,'130406','峰峰矿区','130400'),(89,'130421','邯郸县','130400'),(90,'130423','临漳县','130400'),(91,'130424','成安县','130400'),(92,'130425','大名县','130400'),(93,'130426','涉　县','130400'),(94,'130427','磁　县','130400'),(95,'130428','肥乡县','130400'),(96,'130429','永年县','130400'),(97,'130430','邱　县','130400'),(98,'130431','鸡泽县','130400'),(99,'130432','广平县','130400'),(100,'130433','馆陶县','130400'),(101,'130434','魏　县','130400'),(102,'130435','曲周县','130400'),(103,'130481','武安市','130400'),(104,'130501','市辖区','130500'),(105,'130502','桥东区','130500'),(106,'130503','桥西区','130500'),(107,'130521','邢台县','130500'),(108,'130522','临城县','130500'),(109,'130523','内丘县','130500'),(110,'130524','柏乡县','130500'),(111,'130525','隆尧县','130500'),(112,'130526','任　县','130500'),(113,'130527','南和县','130500'),(114,'130528','宁晋县','130500'),(115,'130529','巨鹿县','130500'),(116,'130530','新河县','130500'),(117,'130531','广宗县','130500'),(118,'130532','平乡县','130500'),(119,'130533','威　县','130500'),(120,'130534','清河县','130500'),(121,'130535','临西县','130500'),(122,'130581','南宫市','130500'),(123,'130582','沙河市','130500'),(124,'130601','市辖区','130600'),(125,'130602','新市区','130600'),(126,'130603','北市区','130600'),(127,'130604','南市区','130600'),(128,'130621','满城县','130600'),(129,'130622','清苑县','130600'),(130,'130623','涞水县','130600'),(131,'130624','阜平县','130600'),(132,'130625','徐水县','130600'),(133,'130626','定兴县','130600'),(134,'130627','唐　县','130600'),(135,'130628','高阳县','130600'),(136,'130629','容城县','130600'),(137,'130630','涞源县','130600'),(138,'130631','望都县','130600'),(139,'130632','安新县','130600'),(140,'130633','易　县','130600'),(141,'130634','曲阳县','130600'),(142,'130635','蠡　县','130600'),(143,'130636','顺平县','130600'),(144,'130637','博野县','130600'),(145,'130638','雄　县','130600'),(146,'130681','涿州市','130600'),(147,'130682','定州市','130600'),(148,'130683','安国市','130600'),(149,'130684','高碑店市','130600'),(150,'130701','市辖区','130700'),(151,'130702','桥东区','130700'),(152,'130703','桥西区','130700'),(153,'130705','宣化区','130700'),(154,'130706','下花园区','130700'),(155,'130721','宣化县','130700'),(156,'130722','张北县','130700'),(157,'130723','康保县','130700'),(158,'130724','沽源县','130700'),(159,'130725','尚义县','130700'),(160,'130726','蔚　县','130700'),(161,'130727','阳原县','130700'),(162,'130728','怀安县','130700'),(163,'130729','万全县','130700'),(164,'130730','怀来县','130700'),(165,'130731','涿鹿县','130700'),(166,'130732','赤城县','130700'),(167,'130733','崇礼县','130700'),(168,'130801','市辖区','130800'),(169,'130802','双桥区','130800'),(170,'130803','双滦区','130800'),(171,'130804','鹰手营子矿区','130800'),(172,'130821','承德县','130800'),(173,'130822','兴隆县','130800'),(174,'130823','平泉县','130800'),(175,'130824','滦平县','130800'),(176,'130825','隆化县','130800'),(177,'130826','丰宁满族自治县','130800'),(178,'130827','宽城满族自治县','130800'),(179,'130828','围场满族蒙古族自治县','130800'),(180,'130901','市辖区','130900'),(181,'130902','新华区','130900'),(182,'130903','运河区','130900'),(183,'130921','沧　县','130900'),(184,'130922','青　县','130900'),(185,'130923','东光县','130900'),(186,'130924','海兴县','130900'),(187,'130925','盐山县','130900'),(188,'130926','肃宁县','130900'),(189,'130927','南皮县','130900'),(190,'130928','吴桥县','130900'),(191,'130929','献　县','130900'),(192,'130930','孟村回族自治县','130900'),(193,'130981','泊头市','130900'),(194,'130982','任丘市','130900'),(195,'130983','黄骅市','130900'),(196,'130984','河间市','130900'),(197,'131001','市辖区','131000'),(198,'131002','安次区','131000'),(199,'131003','广阳区','131000'),(200,'131022','固安县','131000'),(201,'131023','永清县','131000'),(202,'131024','香河县','131000'),(203,'131025','大城县','131000'),(204,'131026','文安县','131000'),(205,'131028','大厂回族自治县','131000'),(206,'131081','霸州市','131000'),(207,'131082','三河市','131000'),(208,'131101','市辖区','131100'),(209,'131102','桃城区','131100'),(210,'131121','枣强县','131100'),(211,'131122','武邑县','131100'),(212,'131123','武强县','131100'),(213,'131124','饶阳县','131100'),(214,'131125','安平县','131100'),(215,'131126','故城县','131100'),(216,'131127','景　县','131100'),(217,'131128','阜城县','131100'),(218,'131181','冀州市','131100'),(219,'131182','深州市','131100'),(220,'140101','市辖区','140100'),(221,'140105','小店区','140100'),(222,'140106','迎泽区','140100'),(223,'140107','杏花岭区','140100'),(224,'140108','尖草坪区','140100'),(225,'140109','万柏林区','140100'),(226,'140110','晋源区','140100'),(227,'140121','清徐县','140100'),(228,'140122','阳曲县','140100'),(229,'140123','娄烦县','140100'),(230,'140181','古交市','140100'),(231,'140201','市辖区','140200'),(232,'140202','城　区','140200'),(233,'140203','矿　区','140200'),(234,'140211','南郊区','140200'),(235,'140212','新荣区','140200'),(236,'140221','阳高县','140200'),(237,'140222','天镇县','140200'),(238,'140223','广灵县','140200'),(239,'140224','灵丘县','140200'),(240,'140225','浑源县','140200'),(241,'140226','左云县','140200'),(242,'140227','大同县','140200'),(243,'140301','市辖区','140300'),(244,'140302','城　区','140300'),(245,'140303','矿　区','140300'),(246,'140311','郊　区','140300'),(247,'140321','平定县','140300'),(248,'140322','盂　县','140300'),(249,'140401','市辖区','140400'),(250,'140402','城　区','140400'),(251,'140411','郊　区','140400'),(252,'140421','长治县','140400'),(253,'140423','襄垣县','140400'),(254,'140424','屯留县','140400'),(255,'140425','平顺县','140400'),(256,'140426','黎城县','140400'),(257,'140427','壶关县','140400'),(258,'140428','长子县','140400'),(259,'140429','武乡县','140400'),(260,'140430','沁　县','140400'),(261,'140431','沁源县','140400'),(262,'140481','潞城市','140400'),(263,'140501','市辖区','140500'),(264,'140502','城　区','140500'),(265,'140521','沁水县','140500'),(266,'140522','阳城县','140500'),(267,'140524','陵川县','140500'),(268,'140525','泽州县','140500'),(269,'140581','高平市','140500'),(270,'140601','市辖区','140600'),(271,'140602','朔城区','140600'),(272,'140603','平鲁区','140600'),(273,'140621','山阴县','140600'),(274,'140622','应　县','140600'),(275,'140623','右玉县','140600'),(276,'140624','怀仁县','140600'),(277,'140701','市辖区','140700'),(278,'140702','榆次区','140700'),(279,'140721','榆社县','140700'),(280,'140722','左权县','140700'),(281,'140723','和顺县','140700'),(282,'140724','昔阳县','140700'),(283,'140725','寿阳县','140700'),(284,'140726','太谷县','140700'),(285,'140727','祁　县','140700'),(286,'140728','平遥县','140700'),(287,'140729','灵石县','140700'),(288,'140781','介休市','140700'),(289,'140801','市辖区','140800'),(290,'140802','盐湖区','140800'),(291,'140821','临猗县','140800'),(292,'140822','万荣县','140800'),(293,'140823','闻喜县','140800'),(294,'140824','稷山县','140800'),(295,'140825','新绛县','140800'),(296,'140826','绛　县','140800'),(297,'140827','垣曲县','140800'),(298,'140828','夏　县','140800'),(299,'140829','平陆县','140800'),(300,'140830','芮城县','140800'),(301,'140881','永济市','140800'),(302,'140882','河津市','140800'),(303,'140901','市辖区','140900'),(304,'140902','忻府区','140900'),(305,'140921','定襄县','140900'),(306,'140922','五台县','140900'),(307,'140923','代　县','140900'),(308,'140924','繁峙县','140900'),(309,'140925','宁武县','140900'),(310,'140926','静乐县','140900'),(311,'140927','神池县','140900'),(312,'140928','五寨县','140900'),(313,'140929','岢岚县','140900'),(314,'140930','河曲县','140900'),(315,'140931','保德县','140900'),(316,'140932','偏关县','140900'),(317,'140981','原平市','140900'),(318,'141001','市辖区','141000'),(319,'141002','尧都区','141000'),(320,'141021','曲沃县','141000'),(321,'141022','翼城县','141000'),(322,'141023','襄汾县','141000'),(323,'141024','洪洞县','141000'),(324,'141025','古　县','141000'),(325,'141026','安泽县','141000'),(326,'141027','浮山县','141000'),(327,'141028','吉　县','141000'),(328,'141029','乡宁县','141000'),(329,'141030','大宁县','141000'),(330,'141031','隰　县','141000'),(331,'141032','永和县','141000'),(332,'141033','蒲　县','141000'),(333,'141034','汾西县','141000'),(334,'141081','侯马市','141000'),(335,'141082','霍州市','141000'),(336,'141101','市辖区','141100'),(337,'141102','离石区','141100'),(338,'141121','文水县','141100'),(339,'141122','交城县','141100'),(340,'141123','兴　县','141100'),(341,'141124','临　县','141100'),(342,'141125','柳林县','141100'),(343,'141126','石楼县','141100'),(344,'141127','岚　县','141100'),(345,'141128','方山县','141100'),(346,'141129','中阳县','141100'),(347,'141130','交口县','141100'),(348,'141181','孝义市','141100'),(349,'141182','汾阳市','141100'),(350,'150101','市辖区','150100'),(351,'150102','新城区','150100'),(352,'150103','回民区','150100'),(353,'150104','玉泉区','150100'),(354,'150105','赛罕区','150100'),(355,'150121','土默特左旗','150100'),(356,'150122','托克托县','150100'),(357,'150123','和林格尔县','150100'),(358,'150124','清水河县','150100'),(359,'150125','武川县','150100'),(360,'150201','市辖区','150200'),(361,'150202','东河区','150200'),(362,'150203','昆都仑区','150200'),(363,'150204','青山区','150200'),(364,'150205','石拐区','150200'),(365,'150206','白云矿区','150200'),(366,'150207','九原区','150200'),(367,'150221','土默特右旗','150200'),(368,'150222','固阳县','150200'),(369,'150223','达尔罕茂明安联合旗','150200'),(370,'150301','市辖区','150300'),(371,'150302','海勃湾区','150300'),(372,'150303','海南区','150300'),(373,'150304','乌达区','150300'),(374,'150401','市辖区','150400'),(375,'150402','红山区','150400'),(376,'150403','元宝山区','150400'),(377,'150404','松山区','150400'),(378,'150421','阿鲁科尔沁旗','150400'),(379,'150422','巴林左旗','150400'),(380,'150423','巴林右旗','150400'),(381,'150424','林西县','150400'),(382,'150425','克什克腾旗','150400'),(383,'150426','翁牛特旗','150400'),(384,'150428','喀喇沁旗','150400'),(385,'150429','宁城县','150400'),(386,'150430','敖汉旗','150400'),(387,'150501','市辖区','150500'),(388,'150502','科尔沁区','150500'),(389,'150521','科尔沁左翼中旗','150500'),(390,'150522','科尔沁左翼后旗','150500'),(391,'150523','开鲁县','150500'),(392,'150524','库伦旗','150500'),(393,'150525','奈曼旗','150500'),(394,'150526','扎鲁特旗','150500'),(395,'150581','霍林郭勒市','150500'),(396,'150602','东胜区','150600'),(397,'150621','达拉特旗','150600'),(398,'150622','准格尔旗','150600'),(399,'150623','鄂托克前旗','150600'),(400,'150624','鄂托克旗','150600'),(401,'150625','杭锦旗','150600'),(402,'150626','乌审旗','150600'),(403,'150627','伊金霍洛旗','150600'),(404,'150701','市辖区','150700'),(405,'150702','海拉尔区','150700'),(406,'150721','阿荣旗','150700'),(407,'150722','莫力达瓦达斡尔族自治旗','150700'),(408,'150723','鄂伦春自治旗','150700'),(409,'150724','鄂温克族自治旗','150700'),(410,'150725','陈巴尔虎旗','150700'),(411,'150726','新巴尔虎左旗','150700'),(412,'150727','新巴尔虎右旗','150700'),(413,'150781','满洲里市','150700'),(414,'150782','牙克石市','150700'),(415,'150783','扎兰屯市','150700'),(416,'150784','额尔古纳市','150700'),(417,'150785','根河市','150700'),(418,'150801','市辖区','150800'),(419,'150802','临河区','150800'),(420,'150821','五原县','150800'),(421,'150822','磴口县','150800'),(422,'150823','乌拉特前旗','150800'),(423,'150824','乌拉特中旗','150800'),(424,'150825','乌拉特后旗','150800'),(425,'150826','杭锦后旗','150800'),(426,'150901','市辖区','150900'),(427,'150902','集宁区','150900'),(428,'150921','卓资县','150900'),(429,'150922','化德县','150900'),(430,'150923','商都县','150900'),(431,'150924','兴和县','150900'),(432,'150925','凉城县','150900'),(433,'150926','察哈尔右翼前旗','150900'),(434,'150927','察哈尔右翼中旗','150900'),(435,'150928','察哈尔右翼后旗','150900'),(436,'150929','四子王旗','150900'),(437,'150981','丰镇市','150900'),(438,'152201','乌兰浩特市','152200'),(439,'152202','阿尔山市','152200'),(440,'152221','科尔沁右翼前旗','152200'),(441,'152222','科尔沁右翼中旗','152200'),(442,'152223','扎赉特旗','152200'),(443,'152224','突泉县','152200'),(444,'152501','二连浩特市','152500'),(445,'152502','锡林浩特市','152500'),(446,'152522','阿巴嘎旗','152500'),(447,'152523','苏尼特左旗','152500'),(448,'152524','苏尼特右旗','152500'),(449,'152525','东乌珠穆沁旗','152500'),(450,'152526','西乌珠穆沁旗','152500'),(451,'152527','太仆寺旗','152500'),(452,'152528','镶黄旗','152500'),(453,'152529','正镶白旗','152500'),(454,'152530','正蓝旗','152500'),(455,'152531','多伦县','152500'),(456,'152921','阿拉善左旗','152900'),(457,'152922','阿拉善右旗','152900'),(458,'152923','额济纳旗','152900'),(459,'210101','市辖区','210100'),(460,'210102','和平区','210100'),(461,'210103','沈河区','210100'),(462,'210104','大东区','210100'),(463,'210105','皇姑区','210100'),(464,'210106','铁西区','210100'),(465,'210111','苏家屯区','210100'),(466,'210112','东陵区','210100'),(467,'210113','新城子区','210100'),(468,'210114','于洪区','210100'),(469,'210122','辽中县','210100'),(470,'210123','康平县','210100'),(471,'210124','法库县','210100'),(472,'210181','新民市','210100'),(473,'210201','市辖区','210200'),(474,'210202','中山区','210200'),(475,'210203','西岗区','210200'),(476,'210204','沙河口区','210200'),(477,'210211','甘井子区','210200'),(478,'210212','旅顺口区','210200'),(479,'210213','金州区','210200'),(480,'210224','长海县','210200'),(481,'210281','瓦房店市','210200'),(482,'210282','普兰店市','210200'),(483,'210283','庄河市','210200'),(484,'210301','市辖区','210300'),(485,'210302','铁东区','210300'),(486,'210303','铁西区','210300'),(487,'210304','立山区','210300'),(488,'210311','千山区','210300'),(489,'210321','台安县','210300'),(490,'210323','岫岩满族自治县','210300'),(491,'210381','海城市','210300'),(492,'210401','市辖区','210400'),(493,'210402','新抚区','210400'),(494,'210403','东洲区','210400'),(495,'210404','望花区','210400'),(496,'210411','顺城区','210400'),(497,'210421','抚顺县','210400'),(498,'210422','新宾满族自治县','210400'),(499,'210423','清原满族自治县','210400'),(500,'210501','市辖区','210500'),(501,'210502','平山区','210500'),(502,'210503','溪湖区','210500'),(503,'210504','明山区','210500'),(504,'210505','南芬区','210500'),(505,'210521','本溪满族自治县','210500'),(506,'210522','桓仁满族自治县','210500'),(507,'210601','市辖区','210600'),(508,'210602','元宝区','210600'),(509,'210603','振兴区','210600'),(510,'210604','振安区','210600'),(511,'210624','宽甸满族自治县','210600'),(512,'210681','东港市','210600'),(513,'210682','凤城市','210600'),(514,'210701','市辖区','210700'),(515,'210702','古塔区','210700'),(516,'210703','凌河区','210700'),(517,'210711','太和区','210700'),(518,'210726','黑山县','210700'),(519,'210727','义　县','210700'),(520,'210781','凌海市','210700'),(521,'210782','北宁市','210700'),(522,'210801','市辖区','210800'),(523,'210802','站前区','210800'),(524,'210803','西市区','210800'),(525,'210804','鲅鱼圈区','210800'),(526,'210811','老边区','210800'),(527,'210881','盖州市','210800'),(528,'210882','大石桥市','210800'),(529,'210901','市辖区','210900'),(530,'210902','海州区','210900'),(531,'210903','新邱区','210900'),(532,'210904','太平区','210900'),(533,'210905','清河门区','210900'),(534,'210911','细河区','210900'),(535,'210921','阜新蒙古族自治县','210900'),(536,'210922','彰武县','210900'),(537,'211001','市辖区','211000'),(538,'211002','白塔区','211000'),(539,'211003','文圣区','211000'),(540,'211004','宏伟区','211000'),(541,'211005','弓长岭区','211000'),(542,'211011','太子河区','211000'),(543,'211021','辽阳县','211000'),(544,'211081','灯塔市','211000'),(545,'211101','市辖区','211100'),(546,'211102','双台子区','211100'),(547,'211103','兴隆台区','211100'),(548,'211121','大洼县','211100'),(549,'211122','盘山县','211100'),(550,'211201','市辖区','211200'),(551,'211202','银州区','211200'),(552,'211204','清河区','211200'),(553,'211221','铁岭县','211200'),(554,'211223','西丰县','211200'),(555,'211224','昌图县','211200'),(556,'211281','调兵山市','211200'),(557,'211282','开原市','211200'),(558,'211301','市辖区','211300'),(559,'211302','双塔区','211300'),(560,'211303','龙城区','211300'),(561,'211321','朝阳县','211300'),(562,'211322','建平县','211300'),(563,'211324','喀喇沁左翼蒙古族自治县','211300'),(564,'211381','北票市','211300'),(565,'211382','凌源市','211300'),(566,'211401','市辖区','211400'),(567,'211402','连山区','211400'),(568,'211403','龙港区','211400'),(569,'211404','南票区','211400'),(570,'211421','绥中县','211400'),(571,'211422','建昌县','211400'),(572,'211481','兴城市','211400'),(573,'220101','市辖区','220100'),(574,'220102','南关区','220100'),(575,'220103','宽城区','220100'),(576,'220104','朝阳区','220100'),(577,'220105','二道区','220100'),(578,'220106','绿园区','220100'),(579,'220112','双阳区','220100'),(580,'220122','农安县','220100'),(581,'220181','九台市','220100'),(582,'220182','榆树市','220100'),(583,'220183','德惠市','220100'),(584,'220201','市辖区','220200'),(585,'220202','昌邑区','220200'),(586,'220203','龙潭区','220200'),(587,'220204','船营区','220200'),(588,'220211','丰满区','220200'),(589,'220221','永吉县','220200'),(590,'220281','蛟河市','220200'),(591,'220282','桦甸市','220200'),(592,'220283','舒兰市','220200'),(593,'220284','磐石市','220200'),(594,'220301','市辖区','220300'),(595,'220302','铁西区','220300'),(596,'220303','铁东区','220300'),(597,'220322','梨树县','220300'),(598,'220323','伊通满族自治县','220300'),(599,'220381','公主岭市','220300'),(600,'220382','双辽市','220300'),(601,'220401','市辖区','220400'),(602,'220402','龙山区','220400'),(603,'220403','西安区','220400'),(604,'220421','东丰县','220400'),(605,'220422','东辽县','220400'),(606,'220501','市辖区','220500'),(607,'220502','东昌区','220500'),(608,'220503','二道江区','220500'),(609,'220521','通化县','220500'),(610,'220523','辉南县','220500'),(611,'220524','柳河县','220500'),(612,'220581','梅河口市','220500'),(613,'220582','集安市','220500'),(614,'220601','市辖区','220600'),(615,'220602','八道江区','220600'),(616,'220621','抚松县','220600'),(617,'220622','靖宇县','220600'),(618,'220623','长白朝鲜族自治县','220600'),(619,'220625','江源县','220600'),(620,'220681','临江市','220600'),(621,'220701','市辖区','220700'),(622,'220702','宁江区','220700'),(623,'220721','前郭尔罗斯蒙古族自治县','220700'),(624,'220722','长岭县','220700'),(625,'220723','乾安县','220700'),(626,'220724','扶余县','220700'),(627,'220801','市辖区','220800'),(628,'220802','洮北区','220800'),(629,'220821','镇赉县','220800'),(630,'220822','通榆县','220800'),(631,'220881','洮南市','220800'),(632,'220882','大安市','220800'),(633,'222401','延吉市','222400'),(634,'222402','图们市','222400'),(635,'222403','敦化市','222400'),(636,'222404','珲春市','222400'),(637,'222405','龙井市','222400'),(638,'222406','和龙市','222400'),(639,'222424','汪清县','222400'),(640,'222426','安图县','222400'),(641,'230101','市辖区','230100'),(642,'230102','道里区','230100'),(643,'230103','南岗区','230100'),(644,'230104','道外区','230100'),(645,'230106','香坊区','230100'),(646,'230107','动力区','230100'),(647,'230108','平房区','230100'),(648,'230109','松北区','230100'),(649,'230111','呼兰区','230100'),(650,'230123','依兰县','230100'),(651,'230124','方正县','230100'),(652,'230125','宾　县','230100'),(653,'230126','巴彦县','230100'),(654,'230127','木兰县','230100'),(655,'230128','通河县','230100'),(656,'230129','延寿县','230100'),(657,'230181','阿城市','230100'),(658,'230182','双城市','230100'),(659,'230183','尚志市','230100'),(660,'230184','五常市','230100'),(661,'230201','市辖区','230200'),(662,'230202','龙沙区','230200'),(663,'230203','建华区','230200'),(664,'230204','铁锋区','230200'),(665,'230205','昂昂溪区','230200'),(666,'230206','富拉尔基区','230200'),(667,'230207','碾子山区','230200'),(668,'230208','梅里斯达斡尔族区','230200'),(669,'230221','龙江县','230200'),(670,'230223','依安县','230200'),(671,'230224','泰来县','230200'),(672,'230225','甘南县','230200'),(673,'230227','富裕县','230200'),(674,'230229','克山县','230200'),(675,'230230','克东县','230200'),(676,'230231','拜泉县','230200'),(677,'230281','讷河市','230200'),(678,'230301','市辖区','230300'),(679,'230302','鸡冠区','230300'),(680,'230303','恒山区','230300'),(681,'230304','滴道区','230300'),(682,'230305','梨树区','230300'),(683,'230306','城子河区','230300'),(684,'230307','麻山区','230300'),(685,'230321','鸡东县','230300'),(686,'230381','虎林市','230300'),(687,'230382','密山市','230300'),(688,'230401','市辖区','230400'),(689,'230402','向阳区','230400'),(690,'230403','工农区','230400'),(691,'230404','南山区','230400'),(692,'230405','兴安区','230400'),(693,'230406','东山区','230400'),(694,'230407','兴山区','230400'),(695,'230421','萝北县','230400'),(696,'230422','绥滨县','230400'),(697,'230501','市辖区','230500'),(698,'230502','尖山区','230500'),(699,'230503','岭东区','230500'),(700,'230505','四方台区','230500'),(701,'230506','宝山区','230500'),(702,'230521','集贤县','230500'),(703,'230522','友谊县','230500'),(704,'230523','宝清县','230500'),(705,'230524','饶河县','230500'),(706,'230601','市辖区','230600'),(707,'230602','萨尔图区','230600'),(708,'230603','龙凤区','230600'),(709,'230604','让胡路区','230600'),(710,'230605','红岗区','230600'),(711,'230606','大同区','230600'),(712,'230621','肇州县','230600'),(713,'230622','肇源县','230600'),(714,'230623','林甸县','230600'),(715,'230624','杜尔伯特蒙古族自治县','230600'),(716,'230701','市辖区','230700'),(717,'230702','伊春区','230700'),(718,'230703','南岔区','230700'),(719,'230704','友好区','230700'),(720,'230705','西林区','230700'),(721,'230706','翠峦区','230700'),(722,'230707','新青区','230700'),(723,'230708','美溪区','230700'),(724,'230709','金山屯区','230700'),(725,'230710','五营区','230700'),(726,'230711','乌马河区','230700'),(727,'230712','汤旺河区','230700'),(728,'230713','带岭区','230700'),(729,'230714','乌伊岭区','230700'),(730,'230715','红星区','230700'),(731,'230716','上甘岭区','230700'),(732,'230722','嘉荫县','230700'),(733,'230781','铁力市','230700'),(734,'230801','市辖区','230800'),(735,'230802','永红区','230800'),(736,'230803','向阳区','230800'),(737,'230804','前进区','230800'),(738,'230805','东风区','230800'),(739,'230811','郊　区','230800'),(740,'230822','桦南县','230800'),(741,'230826','桦川县','230800'),(742,'230828','汤原县','230800'),(743,'230833','抚远县','230800'),(744,'230881','同江市','230800'),(745,'230882','富锦市','230800'),(746,'230901','市辖区','230900'),(747,'230902','新兴区','230900'),(748,'230903','桃山区','230900'),(749,'230904','茄子河区','230900'),(750,'230921','勃利县','230900'),(751,'231001','市辖区','231000'),(752,'231002','东安区','231000'),(753,'231003','阳明区','231000'),(754,'231004','爱民区','231000'),(755,'231005','西安区','231000'),(756,'231024','东宁县','231000'),(757,'231025','林口县','231000'),(758,'231081','绥芬河市','231000'),(759,'231083','海林市','231000'),(760,'231084','宁安市','231000'),(761,'231085','穆棱市','231000'),(762,'231101','市辖区','231100'),(763,'231102','爱辉区','231100'),(764,'231121','嫩江县','231100'),(765,'231123','逊克县','231100'),(766,'231124','孙吴县','231100'),(767,'231181','北安市','231100'),(768,'231182','五大连池市','231100'),(769,'231201','市辖区','231200'),(770,'231202','北林区','231200'),(771,'231221','望奎县','231200'),(772,'231222','兰西县','231200'),(773,'231223','青冈县','231200'),(774,'231224','庆安县','231200'),(775,'231225','明水县','231200'),(776,'231226','绥棱县','231200'),(777,'231281','安达市','231200'),(778,'231282','肇东市','231200'),(779,'231283','海伦市','231200'),(780,'232721','呼玛县','232700'),(781,'232722','塔河县','232700'),(782,'232723','漠河县','232700'),(783,'310101','黄浦区','310100'),(784,'310103','卢湾区','310100'),(785,'310104','徐汇区','310100'),(786,'310105','长宁区','310100'),(787,'310106','静安区','310100'),(788,'310107','普陀区','310100'),(789,'310108','闸北区','310100'),(790,'310109','虹口区','310100'),(791,'310110','杨浦区','310100'),(792,'310112','闵行区','310100'),(793,'310113','宝山区','310100'),(794,'310114','嘉定区','310100'),(795,'310115','浦东新区','310100'),(796,'310116','金山区','310100'),(797,'310117','松江区','310100'),(798,'310118','青浦区','310100'),(799,'310119','南汇区','310100'),(800,'310120','奉贤区','310100'),(801,'310230','崇明县','310200'),(802,'320101','市辖区','320100'),(803,'320102','玄武区','320100'),(804,'320103','白下区','320100'),(805,'320104','秦淮区','320100'),(806,'320105','建邺区','320100'),(807,'320106','鼓楼区','320100'),(808,'320107','下关区','320100'),(809,'320111','浦口区','320100'),(810,'320113','栖霞区','320100'),(811,'320114','雨花台区','320100'),(812,'320115','江宁区','320100'),(813,'320116','六合区','320100'),(814,'320124','溧水县','320100'),(815,'320125','高淳县','320100'),(816,'320201','市辖区','320200'),(817,'320202','崇安区','320200'),(818,'320203','南长区','320200'),(819,'320204','北塘区','320200'),(820,'320205','锡山区','320200'),(821,'320206','惠山区','320200'),(822,'320211','滨湖区','320200'),(823,'320281','江阴市','320200'),(824,'320282','宜兴市','320200'),(825,'320301','市辖区','320300'),(826,'320302','鼓楼区','320300'),(827,'320303','云龙区','320300'),(828,'320304','九里区','320300'),(829,'320305','贾汪区','320300'),(830,'320311','泉山区','320300'),(831,'320321','丰　县','320300'),(832,'320322','沛　县','320300'),(833,'320323','铜山县','320300'),(834,'320324','睢宁县','320300'),(835,'320381','新沂市','320300'),(836,'320382','邳州市','320300'),(837,'320401','市辖区','320400'),(838,'320402','天宁区','320400'),(839,'320404','钟楼区','320400'),(840,'320405','戚墅堰区','320400'),(841,'320411','新北区','320400'),(842,'320412','武进区','320400'),(843,'320481','溧阳市','320400'),(844,'320482','金坛市','320400'),(845,'320501','市辖区','320500'),(846,'320502','沧浪区','320500'),(847,'320503','平江区','320500'),(848,'320504','金阊区','320500'),(849,'320505','虎丘区','320500'),(850,'320506','吴中区','320500'),(851,'320507','相城区','320500'),(852,'320581','常熟市','320500'),(853,'320582','张家港市','320500'),(854,'320583','昆山市','320500'),(855,'320584','吴江市','320500'),(856,'320585','太仓市','320500'),(857,'320601','市辖区','320600'),(858,'320602','崇川区','320600'),(859,'320611','港闸区','320600'),(860,'320621','海安县','320600'),(861,'320623','如东县','320600'),(862,'320681','启东市','320600'),(863,'320682','如皋市','320600'),(864,'320683','通州市','320600'),(865,'320684','海门市','320600'),(866,'320701','市辖区','320700'),(867,'320703','连云区','320700'),(868,'320705','新浦区','320700'),(869,'320706','海州区','320700'),(870,'320721','赣榆县','320700'),(871,'320722','东海县','320700'),(872,'320723','灌云县','320700'),(873,'320724','灌南县','320700'),(874,'320801','市辖区','320800'),(875,'320802','清河区','320800'),(876,'320803','楚州区','320800'),(877,'320804','淮阴区','320800'),(878,'320811','清浦区','320800'),(879,'320826','涟水县','320800'),(880,'320829','洪泽县','320800'),(881,'320830','盱眙县','320800'),(882,'320831','金湖县','320800'),(883,'320901','市辖区','320900'),(884,'320902','亭湖区','320900'),(885,'320903','盐都区','320900'),(886,'320921','响水县','320900'),(887,'320922','滨海县','320900'),(888,'320923','阜宁县','320900'),(889,'320924','射阳县','320900'),(890,'320925','建湖县','320900'),(891,'320981','东台市','320900'),(892,'320982','大丰市','320900'),(893,'321001','市辖区','321000'),(894,'321002','广陵区','321000'),(895,'321003','邗江区','321000'),(896,'321011','郊　区','321000'),(897,'321023','宝应县','321000'),(898,'321081','仪征市','321000'),(899,'321084','高邮市','321000'),(900,'321088','江都市','321000'),(901,'321101','市辖区','321100'),(902,'321102','京口区','321100'),(903,'321111','润州区','321100'),(904,'321112','丹徒区','321100'),(905,'321181','丹阳市','321100'),(906,'321182','扬中市','321100'),(907,'321183','句容市','321100'),(908,'321201','市辖区','321200'),(909,'321202','海陵区','321200'),(910,'321203','高港区','321200'),(911,'321281','兴化市','321200'),(912,'321282','靖江市','321200'),(913,'321283','泰兴市','321200'),(914,'321284','姜堰市','321200'),(915,'321301','市辖区','321300'),(916,'321302','宿城区','321300'),(917,'321311','宿豫区','321300'),(918,'321322','沭阳县','321300'),(919,'321323','泗阳县','321300'),(920,'321324','泗洪县','321300'),(921,'330101','市辖区','330100'),(922,'330102','上城区','330100'),(923,'330103','下城区','330100'),(924,'330104','江干区','330100'),(925,'330105','拱墅区','330100'),(926,'330106','西湖区','330100'),(927,'330108','滨江区','330100'),(928,'330109','萧山区','330100'),(929,'330110','余杭区','330100'),(930,'330122','桐庐县','330100'),(931,'330127','淳安县','330100'),(932,'330182','建德市','330100'),(933,'330183','富阳市','330100'),(934,'330185','临安市','330100'),(935,'330201','市辖区','330200'),(936,'330203','海曙区','330200'),(937,'330204','江东区','330200'),(938,'330205','江北区','330200'),(939,'330206','北仑区','330200'),(940,'330211','镇海区','330200'),(941,'330212','鄞州区','330200'),(942,'330225','象山县','330200'),(943,'330226','宁海县','330200'),(944,'330281','余姚市','330200'),(945,'330282','慈溪市','330200'),(946,'330283','奉化市','330200'),(947,'330301','市辖区','330300'),(948,'330302','鹿城区','330300'),(949,'330303','龙湾区','330300'),(950,'330304','瓯海区','330300'),(951,'330322','洞头县','330300'),(952,'330324','永嘉县','330300'),(953,'330326','平阳县','330300'),(954,'330327','苍南县','330300'),(955,'330328','文成县','330300'),(956,'330329','泰顺县','330300'),(957,'330381','瑞安市','330300'),(958,'330382','乐清市','330300'),(959,'330401','市辖区','330400'),(960,'330402','秀城区','330400'),(961,'330411','秀洲区','330400'),(962,'330421','嘉善县','330400'),(963,'330424','海盐县','330400'),(964,'330481','海宁市','330400'),(965,'330482','平湖市','330400'),(966,'330483','桐乡市','330400'),(967,'330501','市辖区','330500'),(968,'330502','吴兴区','330500'),(969,'330503','南浔区','330500'),(970,'330521','德清县','330500'),(971,'330522','长兴县','330500'),(972,'330523','安吉县','330500'),(973,'330601','市辖区','330600'),(974,'330602','越城区','330600'),(975,'330621','绍兴县','330600'),(976,'330624','新昌县','330600'),(977,'330681','诸暨市','330600'),(978,'330682','上虞市','330600'),(979,'330683','嵊州市','330600'),(980,'330701','市辖区','330700'),(981,'330702','婺城区','330700'),(982,'330703','金东区','330700'),(983,'330723','武义县','330700'),(984,'330726','浦江县','330700'),(985,'330727','磐安县','330700'),(986,'330781','兰溪市','330700'),(987,'330782','义乌市','330700'),(988,'330783','东阳市','330700'),(989,'330784','永康市','330700'),(990,'330801','市辖区','330800'),(991,'330802','柯城区','330800'),(992,'330803','衢江区','330800'),(993,'330822','常山县','330800'),(994,'330824','开化县','330800'),(995,'330825','龙游县','330800'),(996,'330881','江山市','330800'),(997,'330901','市辖区','330900'),(998,'330902','定海区','330900'),(999,'330903','普陀区','330900'),(1000,'330921','岱山县','330900'),(1001,'330922','嵊泗县','330900'),(1002,'331001','市辖区','331000'),(1003,'331002','椒江区','331000'),(1004,'331003','黄岩区','331000'),(1005,'331004','路桥区','331000'),(1006,'331021','玉环县','331000'),(1007,'331022','三门县','331000'),(1008,'331023','天台县','331000'),(1009,'331024','仙居县','331000'),(1010,'331081','温岭市','331000'),(1011,'331082','临海市','331000'),(1012,'331101','市辖区','331100'),(1013,'331102','莲都区','331100'),(1014,'331121','青田县','331100'),(1015,'331122','缙云县','331100'),(1016,'331123','遂昌县','331100'),(1017,'331124','松阳县','331100'),(1018,'331125','云和县','331100'),(1019,'331126','庆元县','331100'),(1020,'331127','景宁畲族自治县','331100'),(1021,'331181','龙泉市','331100'),(1022,'340101','市辖区','340100'),(1023,'340102','瑶海区','340100'),(1024,'340103','庐阳区','340100'),(1025,'340104','蜀山区','340100'),(1026,'340111','包河区','340100'),(1027,'340121','长丰县','340100'),(1028,'340122','肥东县','340100'),(1029,'340123','肥西县','340100'),(1030,'340201','市辖区','340200'),(1031,'340202','镜湖区','340200'),(1032,'340203','马塘区','340200'),(1033,'340204','新芜区','340200'),(1034,'340207','鸠江区','340200'),(1035,'340221','芜湖县','340200'),(1036,'340222','繁昌县','340200'),(1037,'340223','南陵县','340200'),(1038,'340301','市辖区','340300'),(1039,'340302','龙子湖区','340300'),(1040,'340303','蚌山区','340300'),(1041,'340304','禹会区','340300'),(1042,'340311','淮上区','340300'),(1043,'340321','怀远县','340300'),(1044,'340322','五河县','340300'),(1045,'340323','固镇县','340300'),(1046,'340401','市辖区','340400'),(1047,'340402','大通区','340400'),(1048,'340403','田家庵区','340400'),(1049,'340404','谢家集区','340400'),(1050,'340405','八公山区','340400'),(1051,'340406','潘集区','340400'),(1052,'340421','凤台县','340400'),(1053,'340501','市辖区','340500'),(1054,'340502','金家庄区','340500'),(1055,'340503','花山区','340500'),(1056,'340504','雨山区','340500'),(1057,'340521','当涂县','340500'),(1058,'340601','市辖区','340600'),(1059,'340602','杜集区','340600'),(1060,'340603','相山区','340600'),(1061,'340604','烈山区','340600'),(1062,'340621','濉溪县','340600'),(1063,'340701','市辖区','340700'),(1064,'340702','铜官山区','340700'),(1065,'340703','狮子山区','340700'),(1066,'340711','郊　区','340700'),(1067,'340721','铜陵县','340700'),(1068,'340801','市辖区','340800'),(1069,'340802','迎江区','340800'),(1070,'340803','大观区','340800'),(1071,'340811','郊　区','340800'),(1072,'340822','怀宁县','340800'),(1073,'340823','枞阳县','340800'),(1074,'340824','潜山县','340800'),(1075,'340825','太湖县','340800'),(1076,'340826','宿松县','340800'),(1077,'340827','望江县','340800'),(1078,'340828','岳西县','340800'),(1079,'340881','桐城市','340800'),(1080,'341001','市辖区','341000'),(1081,'341002','屯溪区','341000'),(1082,'341003','黄山区','341000'),(1083,'341004','徽州区','341000'),(1084,'341021','歙　县','341000'),(1085,'341022','休宁县','341000'),(1086,'341023','黟　县','341000'),(1087,'341024','祁门县','341000'),(1088,'341101','市辖区','341100'),(1089,'341102','琅琊区','341100'),(1090,'341103','南谯区','341100'),(1091,'341122','来安县','341100'),(1092,'341124','全椒县','341100'),(1093,'341125','定远县','341100'),(1094,'341126','凤阳县','341100'),(1095,'341181','天长市','341100'),(1096,'341182','明光市','341100'),(1097,'341201','市辖区','341200'),(1098,'341202','颍州区','341200'),(1099,'341203','颍东区','341200'),(1100,'341204','颍泉区','341200'),(1101,'341221','临泉县','341200'),(1102,'341222','太和县','341200'),(1103,'341225','阜南县','341200'),(1104,'341226','颍上县','341200'),(1105,'341282','界首市','341200'),(1106,'341301','市辖区','341300'),(1107,'341302','墉桥区','341300'),(1108,'341321','砀山县','341300'),(1109,'341322','萧　县','341300'),(1110,'341323','灵璧县','341300'),(1111,'341324','泗　县','341300'),(1112,'341401','市辖区','341400'),(1113,'341402','居巢区','341400'),(1114,'341421','庐江县','341400'),(1115,'341422','无为县','341400'),(1116,'341423','含山县','341400'),(1117,'341424','和　县','341400'),(1118,'341501','市辖区','341500'),(1119,'341502','金安区','341500'),(1120,'341503','裕安区','341500'),(1121,'341521','寿　县','341500'),(1122,'341522','霍邱县','341500'),(1123,'341523','舒城县','341500'),(1124,'341524','金寨县','341500'),(1125,'341525','霍山县','341500'),(1126,'341601','市辖区','341600'),(1127,'341602','谯城区','341600'),(1128,'341621','涡阳县','341600'),(1129,'341622','蒙城县','341600'),(1130,'341623','利辛县','341600'),(1131,'341701','市辖区','341700'),(1132,'341702','贵池区','341700'),(1133,'341721','东至县','341700'),(1134,'341722','石台县','341700'),(1135,'341723','青阳县','341700'),(1136,'341801','市辖区','341800'),(1137,'341802','宣州区','341800'),(1138,'341821','郎溪县','341800'),(1139,'341822','广德县','341800'),(1140,'341823','泾　县','341800'),(1141,'341824','绩溪县','341800'),(1142,'341825','旌德县','341800'),(1143,'341881','宁国市','341800'),(1144,'350101','市辖区','350100'),(1145,'350102','鼓楼区','350100'),(1146,'350103','台江区','350100'),(1147,'350104','仓山区','350100'),(1148,'350105','马尾区','350100'),(1149,'350111','晋安区','350100'),(1150,'350121','闽侯县','350100'),(1151,'350122','连江县','350100'),(1152,'350123','罗源县','350100'),(1153,'350124','闽清县','350100'),(1154,'350125','永泰县','350100'),(1155,'350128','平潭县','350100'),(1156,'350181','福清市','350100'),(1157,'350182','长乐市','350100'),(1158,'350201','市辖区','350200'),(1159,'350203','思明区','350200'),(1160,'350205','海沧区','350200'),(1161,'350206','湖里区','350200'),(1162,'350211','集美区','350200'),(1163,'350212','同安区','350200'),(1164,'350213','翔安区','350200'),(1165,'350301','市辖区','350300'),(1166,'350302','城厢区','350300'),(1167,'350303','涵江区','350300'),(1168,'350304','荔城区','350300'),(1169,'350305','秀屿区','350300'),(1170,'350322','仙游县','350300'),(1171,'350401','市辖区','350400'),(1172,'350402','梅列区','350400'),(1173,'350403','三元区','350400'),(1174,'350421','明溪县','350400'),(1175,'350423','清流县','350400'),(1176,'350424','宁化县','350400'),(1177,'350425','大田县','350400'),(1178,'350426','尤溪县','350400'),(1179,'350427','沙　县','350400'),(1180,'350428','将乐县','350400'),(1181,'350429','泰宁县','350400'),(1182,'350430','建宁县','350400'),(1183,'350481','永安市','350400'),(1184,'350501','市辖区','350500'),(1185,'350502','鲤城区','350500'),(1186,'350503','丰泽区','350500'),(1187,'350504','洛江区','350500'),(1188,'350505','泉港区','350500'),(1189,'350521','惠安县','350500'),(1190,'350524','安溪县','350500'),(1191,'350525','永春县','350500'),(1192,'350526','德化县','350500'),(1193,'350527','金门县','350500'),(1194,'350581','石狮市','350500'),(1195,'350582','晋江市','350500'),(1196,'350583','南安市','350500'),(1197,'350601','市辖区','350600'),(1198,'350602','芗城区','350600'),(1199,'350603','龙文区','350600'),(1200,'350622','云霄县','350600'),(1201,'350623','漳浦县','350600'),(1202,'350624','诏安县','350600'),(1203,'350625','长泰县','350600'),(1204,'350626','东山县','350600'),(1205,'350627','南靖县','350600'),(1206,'350628','平和县','350600'),(1207,'350629','华安县','350600'),(1208,'350681','龙海市','350600'),(1209,'350701','市辖区','350700'),(1210,'350702','延平区','350700'),(1211,'350721','顺昌县','350700'),(1212,'350722','浦城县','350700'),(1213,'350723','光泽县','350700'),(1214,'350724','松溪县','350700'),(1215,'350725','政和县','350700'),(1216,'350781','邵武市','350700'),(1217,'350782','武夷山市','350700'),(1218,'350783','建瓯市','350700'),(1219,'350784','建阳市','350700'),(1220,'350801','市辖区','350800'),(1221,'350802','新罗区','350800'),(1222,'350821','长汀县','350800'),(1223,'350822','永定县','350800'),(1224,'350823','上杭县','350800'),(1225,'350824','武平县','350800'),(1226,'350825','连城县','350800'),(1227,'350881','漳平市','350800'),(1228,'350901','市辖区','350900'),(1229,'350902','蕉城区','350900'),(1230,'350921','霞浦县','350900'),(1231,'350922','古田县','350900'),(1232,'350923','屏南县','350900'),(1233,'350924','寿宁县','350900'),(1234,'350925','周宁县','350900'),(1235,'350926','柘荣县','350900'),(1236,'350981','福安市','350900'),(1237,'350982','福鼎市','350900'),(1238,'360101','市辖区','360100'),(1239,'360102','东湖区','360100'),(1240,'360103','西湖区','360100'),(1241,'360104','青云谱区','360100'),(1242,'360105','湾里区','360100'),(1243,'360111','青山湖区','360100'),(1244,'360121','南昌县','360100'),(1245,'360122','新建县','360100'),(1246,'360123','安义县','360100'),(1247,'360124','进贤县','360100'),(1248,'360201','市辖区','360200'),(1249,'360202','昌江区','360200'),(1250,'360203','珠山区','360200'),(1251,'360222','浮梁县','360200'),(1252,'360281','乐平市','360200'),(1253,'360301','市辖区','360300'),(1254,'360302','安源区','360300'),(1255,'360313','湘东区','360300'),(1256,'360321','莲花县','360300'),(1257,'360322','上栗县','360300'),(1258,'360323','芦溪县','360300'),(1259,'360401','市辖区','360400'),(1260,'360402','庐山区','360400'),(1261,'360403','浔阳区','360400'),(1262,'360421','九江县','360400'),(1263,'360423','武宁县','360400'),(1264,'360424','修水县','360400'),(1265,'360425','永修县','360400'),(1266,'360426','德安县','360400'),(1267,'360427','星子县','360400'),(1268,'360428','都昌县','360400'),(1269,'360429','湖口县','360400'),(1270,'360430','彭泽县','360400'),(1271,'360481','瑞昌市','360400'),(1272,'360501','市辖区','360500'),(1273,'360502','渝水区','360500'),(1274,'360521','分宜县','360500'),(1275,'360601','市辖区','360600'),(1276,'360602','月湖区','360600'),(1277,'360622','余江县','360600'),(1278,'360681','贵溪市','360600'),(1279,'360701','市辖区','360700'),(1280,'360702','章贡区','360700'),(1281,'360721','赣　县','360700'),(1282,'360722','信丰县','360700'),(1283,'360723','大余县','360700'),(1284,'360724','上犹县','360700'),(1285,'360725','崇义县','360700'),(1286,'360726','安远县','360700'),(1287,'360727','龙南县','360700'),(1288,'360728','定南县','360700'),(1289,'360729','全南县','360700'),(1290,'360730','宁都县','360700'),(1291,'360731','于都县','360700'),(1292,'360732','兴国县','360700'),(1293,'360733','会昌县','360700'),(1294,'360734','寻乌县','360700'),(1295,'360735','石城县','360700'),(1296,'360781','瑞金市','360700'),(1297,'360782','南康市','360700'),(1298,'360801','市辖区','360800'),(1299,'360802','吉州区','360800'),(1300,'360803','青原区','360800'),(1301,'360821','吉安县','360800'),(1302,'360822','吉水县','360800'),(1303,'360823','峡江县','360800'),(1304,'360824','新干县','360800'),(1305,'360825','永丰县','360800'),(1306,'360826','泰和县','360800'),(1307,'360827','遂川县','360800'),(1308,'360828','万安县','360800'),(1309,'360829','安福县','360800'),(1310,'360830','永新县','360800'),(1311,'360881','井冈山市','360800'),(1312,'360901','市辖区','360900'),(1313,'360902','袁州区','360900'),(1314,'360921','奉新县','360900'),(1315,'360922','万载县','360900'),(1316,'360923','上高县','360900'),(1317,'360924','宜丰县','360900'),(1318,'360925','靖安县','360900'),(1319,'360926','铜鼓县','360900'),(1320,'360981','丰城市','360900'),(1321,'360982','樟树市','360900'),(1322,'360983','高安市','360900'),(1323,'361001','市辖区','361000'),(1324,'361002','临川区','361000'),(1325,'361021','南城县','361000'),(1326,'361022','黎川县','361000'),(1327,'361023','南丰县','361000'),(1328,'361024','崇仁县','361000'),(1329,'361025','乐安县','361000'),(1330,'361026','宜黄县','361000'),(1331,'361027','金溪县','361000'),(1332,'361028','资溪县','361000'),(1333,'361029','东乡县','361000'),(1334,'361030','广昌县','361000'),(1335,'361101','市辖区','361100'),(1336,'361102','信州区','361100'),(1337,'361121','上饶县','361100'),(1338,'361122','广丰县','361100'),(1339,'361123','玉山县','361100'),(1340,'361124','铅山县','361100'),(1341,'361125','横峰县','361100'),(1342,'361126','弋阳县','361100'),(1343,'361127','余干县','361100'),(1344,'361128','鄱阳县','361100'),(1345,'361129','万年县','361100'),(1346,'361130','婺源县','361100'),(1347,'361181','德兴市','361100'),(1348,'370101','市辖区','370100'),(1349,'370102','历下区','370100'),(1350,'370103','市中区','370100'),(1351,'370104','槐荫区','370100'),(1352,'370105','天桥区','370100'),(1353,'370112','历城区','370100'),(1354,'370113','长清区','370100'),(1355,'370124','平阴县','370100'),(1356,'370125','济阳县','370100'),(1357,'370126','商河县','370100'),(1358,'370181','章丘市','370100'),(1359,'370201','市辖区','370200'),(1360,'370202','市南区','370200'),(1361,'370203','市北区','370200'),(1362,'370205','四方区','370200'),(1363,'370211','黄岛区','370200'),(1364,'370212','崂山区','370200'),(1365,'370213','李沧区','370200'),(1366,'370214','城阳区','370200'),(1367,'370281','胶州市','370200'),(1368,'370282','即墨市','370200'),(1369,'370283','平度市','370200'),(1370,'370284','胶南市','370200'),(1371,'370285','莱西市','370200'),(1372,'370301','市辖区','370300'),(1373,'370302','淄川区','370300'),(1374,'370303','张店区','370300'),(1375,'370304','博山区','370300'),(1376,'370305','临淄区','370300'),(1377,'370306','周村区','370300'),(1378,'370321','桓台县','370300'),(1379,'370322','高青县','370300'),(1380,'370323','沂源县','370300'),(1381,'370401','市辖区','370400'),(1382,'370402','市中区','370400'),(1383,'370403','薛城区','370400'),(1384,'370404','峄城区','370400'),(1385,'370405','台儿庄区','370400'),(1386,'370406','山亭区','370400'),(1387,'370481','滕州市','370400'),(1388,'370501','市辖区','370500'),(1389,'370502','东营区','370500'),(1390,'370503','河口区','370500'),(1391,'370521','垦利县','370500'),(1392,'370522','利津县','370500'),(1393,'370523','广饶县','370500'),(1394,'370601','市辖区','370600'),(1395,'370602','芝罘区','370600'),(1396,'370611','福山区','370600'),(1397,'370612','牟平区','370600'),(1398,'370613','莱山区','370600'),(1399,'370634','长岛县','370600'),(1400,'370681','龙口市','370600'),(1401,'370682','莱阳市','370600'),(1402,'370683','莱州市','370600'),(1403,'370684','蓬莱市','370600'),(1404,'370685','招远市','370600'),(1405,'370686','栖霞市','370600'),(1406,'370687','海阳市','370600'),(1407,'370701','市辖区','370700'),(1408,'370702','潍城区','370700'),(1409,'370703','寒亭区','370700'),(1410,'370704','坊子区','370700'),(1411,'370705','奎文区','370700'),(1412,'370724','临朐县','370700'),(1413,'370725','昌乐县','370700'),(1414,'370781','青州市','370700'),(1415,'370782','诸城市','370700'),(1416,'370783','寿光市','370700'),(1417,'370784','安丘市','370700'),(1418,'370785','高密市','370700'),(1419,'370786','昌邑市','370700'),(1420,'370801','市辖区','370800'),(1421,'370802','市中区','370800'),(1422,'370811','任城区','370800'),(1423,'370826','微山县','370800'),(1424,'370827','鱼台县','370800'),(1425,'370828','金乡县','370800'),(1426,'370829','嘉祥县','370800'),(1427,'370830','汶上县','370800'),(1428,'370831','泗水县','370800'),(1429,'370832','梁山县','370800'),(1430,'370881','曲阜市','370800'),(1431,'370882','兖州市','370800'),(1432,'370883','邹城市','370800'),(1433,'370901','市辖区','370900'),(1434,'370902','泰山区','370900'),(1435,'370903','岱岳区','370900'),(1436,'370921','宁阳县','370900'),(1437,'370923','东平县','370900'),(1438,'370982','新泰市','370900'),(1439,'370983','肥城市','370900'),(1440,'371001','市辖区','371000'),(1441,'371002','环翠区','371000'),(1442,'371081','文登市','371000'),(1443,'371082','荣成市','371000'),(1444,'371083','乳山市','371000'),(1445,'371101','市辖区','371100'),(1446,'371102','东港区','371100'),(1447,'371103','岚山区','371100'),(1448,'371121','五莲县','371100'),(1449,'371122','莒　县','371100'),(1450,'371201','市辖区','371200'),(1451,'371202','莱城区','371200'),(1452,'371203','钢城区','371200'),(1453,'371301','市辖区','371300'),(1454,'371302','兰山区','371300'),(1455,'371311','罗庄区','371300'),(1456,'371312','河东区','371300'),(1457,'371321','沂南县','371300'),(1458,'371322','郯城县','371300'),(1459,'371323','沂水县','371300'),(1460,'371324','苍山县','371300'),(1461,'371325','费　县','371300'),(1462,'371326','平邑县','371300'),(1463,'371327','莒南县','371300'),(1464,'371328','蒙阴县','371300'),(1465,'371329','临沭县','371300'),(1466,'371401','市辖区','371400'),(1467,'371402','德城区','371400'),(1468,'371421','陵　县','371400'),(1469,'371422','宁津县','371400'),(1470,'371423','庆云县','371400'),(1471,'371424','临邑县','371400'),(1472,'371425','齐河县','371400'),(1473,'371426','平原县','371400'),(1474,'371427','夏津县','371400'),(1475,'371428','武城县','371400'),(1476,'371481','乐陵市','371400'),(1477,'371482','禹城市','371400'),(1478,'371501','市辖区','371500'),(1479,'371502','东昌府区','371500'),(1480,'371521','阳谷县','371500'),(1481,'371522','莘　县','371500'),(1482,'371523','茌平县','371500'),(1483,'371524','东阿县','371500'),(1484,'371525','冠　县','371500'),(1485,'371526','高唐县','371500'),(1486,'371581','临清市','371500'),(1487,'371601','市辖区','371600'),(1488,'371602','滨城区','371600'),(1489,'371621','惠民县','371600'),(1490,'371622','阳信县','371600'),(1491,'371623','无棣县','371600'),(1492,'371624','沾化县','371600'),(1493,'371625','博兴县','371600'),(1494,'371626','邹平县','371600'),(1495,'371701','市辖区','371700'),(1496,'371702','牡丹区','371700'),(1497,'371721','曹　县','371700'),(1498,'371722','单　县','371700'),(1499,'371723','成武县','371700'),(1500,'371724','巨野县','371700'),(1501,'371725','郓城县','371700'),(1502,'371726','鄄城县','371700'),(1503,'371727','定陶县','371700'),(1504,'371728','东明县','371700'),(1505,'410101','市辖区','410100'),(1506,'410102','中原区','410100'),(1507,'410103','二七区','410100'),(1508,'410104','管城回族区','410100'),(1509,'410105','金水区','410100'),(1510,'410106','上街区','410100'),(1511,'410108','邙山区','410100'),(1512,'410122','中牟县','410100'),(1513,'410181','巩义市','410100'),(1514,'410182','荥阳市','410100'),(1515,'410183','新密市','410100'),(1516,'410184','新郑市','410100'),(1517,'410185','登封市','410100'),(1518,'410201','市辖区','410200'),(1519,'410202','龙亭区','410200'),(1520,'410203','顺河回族区','410200'),(1521,'410204','鼓楼区','410200'),(1522,'410205','南关区','410200'),(1523,'410211','郊　区','410200'),(1524,'410221','杞　县','410200'),(1525,'410222','通许县','410200'),(1526,'410223','尉氏县','410200'),(1527,'410224','开封县','410200'),(1528,'410225','兰考县','410200'),(1529,'410301','市辖区','410300'),(1530,'410302','老城区','410300'),(1531,'410303','西工区','410300'),(1532,'410304','廛河回族区','410300'),(1533,'410305','涧西区','410300'),(1534,'410306','吉利区','410300'),(1535,'410307','洛龙区','410300'),(1536,'410322','孟津县','410300'),(1537,'410323','新安县','410300'),(1538,'410324','栾川县','410300'),(1539,'410325','嵩　县','410300'),(1540,'410326','汝阳县','410300'),(1541,'410327','宜阳县','410300'),(1542,'410328','洛宁县','410300'),(1543,'410329','伊川县','410300'),(1544,'410381','偃师市','410300'),(1545,'410401','市辖区','410400'),(1546,'410402','新华区','410400'),(1547,'410403','卫东区','410400'),(1548,'410404','石龙区','410400'),(1549,'410411','湛河区','410400'),(1550,'410421','宝丰县','410400'),(1551,'410422','叶　县','410400'),(1552,'410423','鲁山县','410400'),(1553,'410425','郏　县','410400'),(1554,'410481','舞钢市','410400'),(1555,'410482','汝州市','410400'),(1556,'410501','市辖区','410500'),(1557,'410502','文峰区','410500'),(1558,'410503','北关区','410500'),(1559,'410505','殷都区','410500'),(1560,'410506','龙安区','410500'),(1561,'410522','安阳县','410500'),(1562,'410523','汤阴县','410500'),(1563,'410526','滑　县','410500'),(1564,'410527','内黄县','410500'),(1565,'410581','林州市','410500'),(1566,'410601','市辖区','410600'),(1567,'410602','鹤山区','410600'),(1568,'410603','山城区','410600'),(1569,'410611','淇滨区','410600'),(1570,'410621','浚　县','410600'),(1571,'410622','淇　县','410600'),(1572,'410701','市辖区','410700'),(1573,'410702','红旗区','410700'),(1574,'410703','卫滨区','410700'),(1575,'410704','凤泉区','410700'),(1576,'410711','牧野区','410700'),(1577,'410721','新乡县','410700'),(1578,'410724','获嘉县','410700'),(1579,'410725','原阳县','410700'),(1580,'410726','延津县','410700'),(1581,'410727','封丘县','410700'),(1582,'410728','长垣县','410700'),(1583,'410781','卫辉市','410700'),(1584,'410782','辉县市','410700'),(1585,'410801','市辖区','410800'),(1586,'410802','解放区','410800'),(1587,'410803','中站区','410800'),(1588,'410804','马村区','410800'),(1589,'410811','山阳区','410800'),(1590,'410821','修武县','410800'),(1591,'410822','博爱县','410800'),(1592,'410823','武陟县','410800'),(1593,'410825','温　县','410800'),(1594,'410881','济源市','410800'),(1595,'410882','沁阳市','410800'),(1596,'410883','孟州市','410800'),(1597,'410901','市辖区','410900'),(1598,'410902','华龙区','410900'),(1599,'410922','清丰县','410900'),(1600,'410923','南乐县','410900'),(1601,'410926','范　县','410900'),(1602,'410927','台前县','410900'),(1603,'410928','濮阳县','410900'),(1604,'411001','市辖区','411000'),(1605,'411002','魏都区','411000'),(1606,'411023','许昌县','411000'),(1607,'411024','鄢陵县','411000'),(1608,'411025','襄城县','411000'),(1609,'411081','禹州市','411000'),(1610,'411082','长葛市','411000'),(1611,'411101','市辖区','411100'),(1612,'411102','源汇区','411100'),(1613,'411103','郾城区','411100'),(1614,'411104','召陵区','411100'),(1615,'411121','舞阳县','411100'),(1616,'411122','临颍县','411100'),(1617,'411201','市辖区','411200'),(1618,'411202','湖滨区','411200'),(1619,'411221','渑池县','411200'),(1620,'411222','陕　县','411200'),(1621,'411224','卢氏县','411200'),(1622,'411281','义马市','411200'),(1623,'411282','灵宝市','411200'),(1624,'411301','市辖区','411300'),(1625,'411302','宛城区','411300'),(1626,'411303','卧龙区','411300'),(1627,'411321','南召县','411300'),(1628,'411322','方城县','411300'),(1629,'411323','西峡县','411300'),(1630,'411324','镇平县','411300'),(1631,'411325','内乡县','411300'),(1632,'411326','淅川县','411300'),(1633,'411327','社旗县','411300'),(1634,'411328','唐河县','411300'),(1635,'411329','新野县','411300'),(1636,'411330','桐柏县','411300'),(1637,'411381','邓州市','411300');

INSERT INTO tb_areas_region (id, areaid, area, cityid) VALUES (1638,'411401','市辖区','411400'),(1639,'411402','梁园区','411400'),(1640,'411403','睢阳区','411400'),(1641,'411421','民权县','411400'),(1642,'411422','睢　县','411400'),(1643,'411423','宁陵县','411400'),(1644,'411424','柘城县','411400'),(1645,'411425','虞城县','411400'),(1646,'411426','夏邑县','411400'),(1647,'411481','永城市','411400'),(1648,'411501','市辖区','411500'),(1649,'411502','师河区','411500'),(1650,'411503','平桥区','411500'),(1651,'411521','罗山县','411500'),(1652,'411522','光山县','411500'),(1653,'411523','新　县','411500'),(1654,'411524','商城县','411500'),(1655,'411525','固始县','411500'),(1656,'411526','潢川县','411500'),(1657,'411527','淮滨县','411500'),(1658,'411528','息　县','411500'),(1659,'411601','市辖区','411600'),(1660,'411602','川汇区','411600'),(1661,'411621','扶沟县','411600'),(1662,'411622','西华县','411600'),(1663,'411623','商水县','411600'),(1664,'411624','沈丘县','411600'),(1665,'411625','郸城县','411600'),(1666,'411626','淮阳县','411600'),(1667,'411627','太康县','411600'),(1668,'411628','鹿邑县','411600'),(1669,'411681','项城市','411600'),(1670,'411701','市辖区','411700'),(1671,'411702','驿城区','411700'),(1672,'411721','西平县','411700'),(1673,'411722','上蔡县','411700'),(1674,'411723','平舆县','411700'),(1675,'411724','正阳县','411700'),(1676,'411725','确山县','411700'),(1677,'411726','泌阳县','411700'),(1678,'411727','汝南县','411700'),(1679,'411728','遂平县','411700'),(1680,'411729','新蔡县','411700'),(1681,'420101','市辖区','420100'),(1682,'420102','江岸区','420100'),(1683,'420103','江汉区','420100'),(1684,'420104','乔口区','420100'),(1685,'420105','汉阳区','420100'),(1686,'420106','武昌区','420100'),(1687,'420107','青山区','420100'),(1688,'420111','洪山区','420100'),(1689,'420112','东西湖区','420100'),(1690,'420113','汉南区','420100'),(1691,'420114','蔡甸区','420100'),(1692,'420115','江夏区','420100'),(1693,'420116','黄陂区','420100'),(1694,'420117','新洲区','420100'),(1695,'420201','市辖区','420200'),(1696,'420202','黄石港区','420200'),(1697,'420203','西塞山区','420200'),(1698,'420204','下陆区','420200'),(1699,'420205','铁山区','420200'),(1700,'420222','阳新县','420200'),(1701,'420281','大冶市','420200'),(1702,'420301','市辖区','420300'),(1703,'420302','茅箭区','420300'),(1704,'420303','张湾区','420300'),(1705,'420321','郧　县','420300'),(1706,'420322','郧西县','420300'),(1707,'420323','竹山县','420300'),(1708,'420324','竹溪县','420300'),(1709,'420325','房　县','420300'),(1710,'420381','丹江口市','420300'),(1711,'420501','市辖区','420500'),(1712,'420502','西陵区','420500'),(1713,'420503','伍家岗区','420500'),(1714,'420504','点军区','420500'),(1715,'420505','猇亭区','420500'),(1716,'420506','夷陵区','420500'),(1717,'420525','远安县','420500'),(1718,'420526','兴山县','420500'),(1719,'420527','秭归县','420500'),(1720,'420528','长阳土家族自治县','420500'),(1721,'420529','五峰土家族自治县','420500'),(1722,'420581','宜都市','420500'),(1723,'420582','当阳市','420500'),(1724,'420583','枝江市','420500'),(1725,'420601','市辖区','420600'),(1726,'420602','襄城区','420600'),(1727,'420606','樊城区','420600'),(1728,'420607','襄阳区','420600'),(1729,'420624','南漳县','420600'),(1730,'420625','谷城县','420600'),(1731,'420626','保康县','420600'),(1732,'420682','老河口市','420600'),(1733,'420683','枣阳市','420600'),(1734,'420684','宜城市','420600'),(1735,'420701','市辖区','420700'),(1736,'420702','梁子湖区','420700'),(1737,'420703','华容区','420700'),(1738,'420704','鄂城区','420700'),(1739,'420801','市辖区','420800'),(1740,'420802','东宝区','420800'),(1741,'420804','掇刀区','420800'),(1742,'420821','京山县','420800'),(1743,'420822','沙洋县','420800'),(1744,'420881','钟祥市','420800'),(1745,'420901','市辖区','420900'),(1746,'420902','孝南区','420900'),(1747,'420921','孝昌县','420900'),(1748,'420922','大悟县','420900'),(1749,'420923','云梦县','420900'),(1750,'420981','应城市','420900'),(1751,'420982','安陆市','420900'),(1752,'420984','汉川市','420900'),(1753,'421001','市辖区','421000'),(1754,'421002','沙市区','421000'),(1755,'421003','荆州区','421000'),(1756,'421022','公安县','421000'),(1757,'421023','监利县','421000'),(1758,'421024','江陵县','421000'),(1759,'421081','石首市','421000'),(1760,'421083','洪湖市','421000'),(1761,'421087','松滋市','421000'),(1762,'421101','市辖区','421100'),(1763,'421102','黄州区','421100'),(1764,'421121','团风县','421100'),(1765,'421122','红安县','421100'),(1766,'421123','罗田县','421100'),(1767,'421124','英山县','421100'),(1768,'421125','浠水县','421100'),(1769,'421126','蕲春县','421100'),(1770,'421127','黄梅县','421100'),(1771,'421181','麻城市','421100'),(1772,'421182','武穴市','421100'),(1773,'421201','市辖区','421200'),(1774,'421202','咸安区','421200'),(1775,'421221','嘉鱼县','421200'),(1776,'421222','通城县','421200'),(1777,'421223','崇阳县','421200'),(1778,'421224','通山县','421200'),(1779,'421281','赤壁市','421200'),(1780,'421301','市辖区','421300'),(1781,'421302','曾都区','421300'),(1782,'421381','广水市','421300'),(1783,'422801','恩施市','422800'),(1784,'422802','利川市','422800'),(1785,'422822','建始县','422800'),(1786,'422823','巴东县','422800'),(1787,'422825','宣恩县','422800'),(1788,'422826','咸丰县','422800'),(1789,'422827','来凤县','422800'),(1790,'422828','鹤峰县','422800'),(1791,'429004','仙桃市','429000'),(1792,'429005','潜江市','429000'),(1793,'429006','天门市','429000'),(1794,'429021','神农架林区','429000'),(1795,'430101','市辖区','430100'),(1796,'430102','芙蓉区','430100'),(1797,'430103','天心区','430100'),(1798,'430104','岳麓区','430100'),(1799,'430105','开福区','430100'),(1800,'430111','雨花区','430100'),(1801,'430121','长沙县','430100'),(1802,'430122','望城县','430100'),(1803,'430124','宁乡县','430100'),(1804,'430181','浏阳市','430100'),(1805,'430201','市辖区','430200'),(1806,'430202','荷塘区','430200'),(1807,'430203','芦淞区','430200'),(1808,'430204','石峰区','430200'),(1809,'430211','天元区','430200'),(1810,'430221','株洲县','430200'),(1811,'430223','攸　县','430200'),(1812,'430224','茶陵县','430200'),(1813,'430225','炎陵县','430200'),(1814,'430281','醴陵市','430200'),(1815,'430301','市辖区','430300'),(1816,'430302','雨湖区','430300'),(1817,'430304','岳塘区','430300'),(1818,'430321','湘潭县','430300'),(1819,'430381','湘乡市','430300'),(1820,'430382','韶山市','430300'),(1821,'430401','市辖区','430400'),(1822,'430405','珠晖区','430400'),(1823,'430406','雁峰区','430400'),(1824,'430407','石鼓区','430400'),(1825,'430408','蒸湘区','430400'),(1826,'430412','南岳区','430400'),(1827,'430421','衡阳县','430400'),(1828,'430422','衡南县','430400'),(1829,'430423','衡山县','430400'),(1830,'430424','衡东县','430400'),(1831,'430426','祁东县','430400'),(1832,'430481','耒阳市','430400'),(1833,'430482','常宁市','430400'),(1834,'430501','市辖区','430500'),(1835,'430502','双清区','430500'),(1836,'430503','大祥区','430500'),(1837,'430511','北塔区','430500'),(1838,'430521','邵东县','430500'),(1839,'430522','新邵县','430500'),(1840,'430523','邵阳县','430500'),(1841,'430524','隆回县','430500'),(1842,'430525','洞口县','430500'),(1843,'430527','绥宁县','430500'),(1844,'430528','新宁县','430500'),(1845,'430529','城步苗族自治县','430500'),(1846,'430581','武冈市','430500'),(1847,'430601','市辖区','430600'),(1848,'430602','岳阳楼区','430600'),(1849,'430603','云溪区','430600'),(1850,'430611','君山区','430600'),(1851,'430621','岳阳县','430600'),(1852,'430623','华容县','430600'),(1853,'430624','湘阴县','430600'),(1854,'430626','平江县','430600'),(1855,'430681','汨罗市','430600'),(1856,'430682','临湘市','430600'),(1857,'430701','市辖区','430700'),(1858,'430702','武陵区','430700'),(1859,'430703','鼎城区','430700'),(1860,'430721','安乡县','430700'),(1861,'430722','汉寿县','430700'),(1862,'430723','澧　县','430700'),(1863,'430724','临澧县','430700'),(1864,'430725','桃源县','430700'),(1865,'430726','石门县','430700'),(1866,'430781','津市市','430700'),(1867,'430801','市辖区','430800'),(1868,'430802','永定区','430800'),(1869,'430811','武陵源区','430800'),(1870,'430821','慈利县','430800'),(1871,'430822','桑植县','430800'),(1872,'430901','市辖区','430900'),(1873,'430902','资阳区','430900'),(1874,'430903','赫山区','430900'),(1875,'430921','南　县','430900'),(1876,'430922','桃江县','430900'),(1877,'430923','安化县','430900'),(1878,'430981','沅江市','430900'),(1879,'431001','市辖区','431000'),(1880,'431002','北湖区','431000'),(1881,'431003','苏仙区','431000'),(1882,'431021','桂阳县','431000'),(1883,'431022','宜章县','431000'),(1884,'431023','永兴县','431000'),(1885,'431024','嘉禾县','431000'),(1886,'431025','临武县','431000'),(1887,'431026','汝城县','431000'),(1888,'431027','桂东县','431000'),(1889,'431028','安仁县','431000'),(1890,'431081','资兴市','431000'),(1891,'431101','市辖区','431100'),(1892,'431102','芝山区','431100'),(1893,'431103','冷水滩区','431100'),(1894,'431121','祁阳县','431100'),(1895,'431122','东安县','431100'),(1896,'431123','双牌县','431100'),(1897,'431124','道　县','431100'),(1898,'431125','江永县','431100'),(1899,'431126','宁远县','431100'),(1900,'431127','蓝山县','431100'),(1901,'431128','新田县','431100'),(1902,'431129','江华瑶族自治县','431100'),(1903,'431201','市辖区','431200'),(1904,'431202','鹤城区','431200'),(1905,'431221','中方县','431200'),(1906,'431222','沅陵县','431200'),(1907,'431223','辰溪县','431200'),(1908,'431224','溆浦县','431200'),(1909,'431225','会同县','431200'),(1910,'431226','麻阳苗族自治县','431200'),(1911,'431227','新晃侗族自治县','431200'),(1912,'431228','芷江侗族自治县','431200'),(1913,'431229','靖州苗族侗族自治县','431200'),(1914,'431230','通道侗族自治县','431200'),(1915,'431281','洪江市','431200'),(1916,'431301','市辖区','431300'),(1917,'431302','娄星区','431300'),(1918,'431321','双峰县','431300'),(1919,'431322','新化县','431300'),(1920,'431381','冷水江市','431300'),(1921,'431382','涟源市','431300'),(1922,'433101','吉首市','433100'),(1923,'433122','泸溪县','433100'),(1924,'433123','凤凰县','433100'),(1925,'433124','花垣县','433100'),(1926,'433125','保靖县','433100'),(1927,'433126','古丈县','433100'),(1928,'433127','永顺县','433100'),(1929,'433130','龙山县','433100'),(1930,'440101','市辖区','440100'),(1931,'440102','东山区','440100'),(1932,'440103','荔湾区','440100'),(1933,'440104','越秀区','440100'),(1934,'440105','海珠区','440100'),(1935,'440106','天河区','440100'),(1936,'440107','芳村区','440100'),(1937,'440111','白云区','440100'),(1938,'440112','黄埔区','440100'),(1939,'440113','番禺区','440100'),(1940,'440114','花都区','440100'),(1941,'440183','增城市','440100'),(1942,'440184','从化市','440100'),(1943,'440201','市辖区','440200'),(1944,'440203','武江区','440200'),(1945,'440204','浈江区','440200'),(1946,'440205','曲江区','440200'),(1947,'440222','始兴县','440200'),(1948,'440224','仁化县','440200'),(1949,'440229','翁源县','440200'),(1950,'440232','乳源瑶族自治县','440200'),(1951,'440233','新丰县','440200'),(1952,'440281','乐昌市','440200'),(1953,'440282','南雄市','440200'),(1954,'440301','市辖区','440300'),(1955,'440303','罗湖区','440300'),(1956,'440304','福田区','440300'),(1957,'440305','南山区','440300'),(1958,'440306','宝安区','440300'),(1959,'440307','龙岗区','440300'),(1960,'440308','盐田区','440300'),(1961,'440401','市辖区','440400'),(1962,'440402','香洲区','440400'),(1963,'440403','斗门区','440400'),(1964,'440404','金湾区','440400'),(1965,'440501','市辖区','440500'),(1966,'440507','龙湖区','440500'),(1967,'440511','金平区','440500'),(1968,'440512','濠江区','440500'),(1969,'440513','潮阳区','440500'),(1970,'440514','潮南区','440500'),(1971,'440515','澄海区','440500'),(1972,'440523','南澳县','440500'),(1973,'440601','市辖区','440600'),(1974,'440604','禅城区','440600'),(1975,'440605','南海区','440600'),(1976,'440606','顺德区','440600'),(1977,'440607','三水区','440600'),(1978,'440608','高明区','440600'),(1979,'440701','市辖区','440700'),(1980,'440703','蓬江区','440700'),(1981,'440704','江海区','440700'),(1982,'440705','新会区','440700'),(1983,'440781','台山市','440700'),(1984,'440783','开平市','440700'),(1985,'440784','鹤山市','440700'),(1986,'440785','恩平市','440700'),(1987,'440801','市辖区','440800'),(1988,'440802','赤坎区','440800'),(1989,'440803','霞山区','440800'),(1990,'440804','坡头区','440800'),(1991,'440811','麻章区','440800'),(1992,'440823','遂溪县','440800'),(1993,'440825','徐闻县','440800'),(1994,'440881','廉江市','440800'),(1995,'440882','雷州市','440800'),(1996,'440883','吴川市','440800'),(1997,'440901','市辖区','440900'),(1998,'440902','茂南区','440900'),(1999,'440903','茂港区','440900'),(2000,'440923','电白县','440900'),(2001,'440981','高州市','440900'),(2002,'440982','化州市','440900'),(2003,'440983','信宜市','440900'),(2004,'441201','市辖区','441200'),(2005,'441202','端州区','441200'),(2006,'441203','鼎湖区','441200'),(2007,'441223','广宁县','441200'),(2008,'441224','怀集县','441200'),(2009,'441225','封开县','441200'),(2010,'441226','德庆县','441200'),(2011,'441283','高要市','441200'),(2012,'441284','四会市','441200'),(2013,'441301','市辖区','441300'),(2014,'441302','惠城区','441300'),(2015,'441303','惠阳区','441300'),(2016,'441322','博罗县','441300'),(2017,'441323','惠东县','441300'),(2018,'441324','龙门县','441300'),(2019,'441401','市辖区','441400'),(2020,'441402','梅江区','441400'),(2021,'441421','梅　县','441400'),(2022,'441422','大埔县','441400'),(2023,'441423','丰顺县','441400'),(2024,'441424','五华县','441400'),(2025,'441426','平远县','441400'),(2026,'441427','蕉岭县','441400'),(2027,'441481','兴宁市','441400'),(2028,'441501','市辖区','441500'),(2029,'441502','城　区','441500'),(2030,'441521','海丰县','441500'),(2031,'441523','陆河县','441500'),(2032,'441581','陆丰市','441500'),(2033,'441601','市辖区','441600'),(2034,'441602','源城区','441600'),(2035,'441621','紫金县','441600'),(2036,'441622','龙川县','441600'),(2037,'441623','连平县','441600'),(2038,'441624','和平县','441600'),(2039,'441625','东源县','441600'),(2040,'441701','市辖区','441700'),(2041,'441702','江城区','441700'),(2042,'441721','阳西县','441700'),(2043,'441723','阳东县','441700'),(2044,'441781','阳春市','441700'),(2045,'441801','市辖区','441800'),(2046,'441802','清城区','441800'),(2047,'441821','佛冈县','441800'),(2048,'441823','阳山县','441800'),(2049,'441825','连山壮族瑶族自治县','441800'),(2050,'441826','连南瑶族自治县','441800'),(2051,'441827','清新县','441800'),(2052,'441881','英德市','441800'),(2053,'441882','连州市','441800'),(2054,'445101','市辖区','445100'),(2055,'445102','湘桥区','445100'),(2056,'445121','潮安县','445100'),(2057,'445122','饶平县','445100'),(2058,'445201','市辖区','445200'),(2059,'445202','榕城区','445200'),(2060,'445221','揭东县','445200'),(2061,'445222','揭西县','445200'),(2062,'445224','惠来县','445200'),(2063,'445281','普宁市','445200'),(2064,'445301','市辖区','445300'),(2065,'445302','云城区','445300'),(2066,'445321','新兴县','445300'),(2067,'445322','郁南县','445300'),(2068,'445323','云安县','445300'),(2069,'445381','罗定市','445300'),(2070,'450101','市辖区','450100'),(2071,'450102','兴宁区','450100'),(2072,'450103','青秀区','450100'),(2073,'450105','江南区','450100'),(2074,'450107','西乡塘区','450100'),(2075,'450108','良庆区','450100'),(2076,'450109','邕宁区','450100'),(2077,'450122','武鸣县','450100'),(2078,'450123','隆安县','450100'),(2079,'450124','马山县','450100'),(2080,'450125','上林县','450100'),(2081,'450126','宾阳县','450100'),(2082,'450127','横　县','450100'),(2083,'450201','市辖区','450200'),(2084,'450202','城中区','450200'),(2085,'450203','鱼峰区','450200'),(2086,'450204','柳南区','450200'),(2087,'450205','柳北区','450200'),(2088,'450221','柳江县','450200'),(2089,'450222','柳城县','450200'),(2090,'450223','鹿寨县','450200'),(2091,'450224','融安县','450200'),(2092,'450225','融水苗族自治县','450200'),(2093,'450226','三江侗族自治县','450200'),(2094,'450301','市辖区','450300'),(2095,'450302','秀峰区','450300'),(2096,'450303','叠彩区','450300'),(2097,'450304','象山区','450300'),(2098,'450305','七星区','450300'),(2099,'450311','雁山区','450300'),(2100,'450321','阳朔县','450300'),(2101,'450322','临桂县','450300'),(2102,'450323','灵川县','450300'),(2103,'450324','全州县','450300'),(2104,'450325','兴安县','450300'),(2105,'450326','永福县','450300'),(2106,'450327','灌阳县','450300'),(2107,'450328','龙胜各族自治县','450300'),(2108,'450329','资源县','450300'),(2109,'450330','平乐县','450300'),(2110,'450331','荔蒲县','450300'),(2111,'450332','恭城瑶族自治县','450300'),(2112,'450401','市辖区','450400'),(2113,'450403','万秀区','450400'),(2114,'450404','蝶山区','450400'),(2115,'450405','长洲区','450400'),(2116,'450421','苍梧县','450400'),(2117,'450422','藤　县','450400'),(2118,'450423','蒙山县','450400'),(2119,'450481','岑溪市','450400'),(2120,'450501','市辖区','450500'),(2121,'450502','海城区','450500'),(2122,'450503','银海区','450500'),(2123,'450512','铁山港区','450500'),(2124,'450521','合浦县','450500'),(2125,'450601','市辖区','450600'),(2126,'450602','港口区','450600'),(2127,'450603','防城区','450600'),(2128,'450621','上思县','450600'),(2129,'450681','东兴市','450600'),(2130,'450701','市辖区','450700'),(2131,'450702','钦南区','450700'),(2132,'450703','钦北区','450700'),(2133,'450721','灵山县','450700'),(2134,'450722','浦北县','450700'),(2135,'450801','市辖区','450800'),(2136,'450802','港北区','450800'),(2137,'450803','港南区','450800'),(2138,'450804','覃塘区','450800'),(2139,'450821','平南县','450800'),(2140,'450881','桂平市','450800'),(2141,'450901','市辖区','450900'),(2142,'450902','玉州区','450900'),(2143,'450921','容　县','450900'),(2144,'450922','陆川县','450900'),(2145,'450923','博白县','450900'),(2146,'450924','兴业县','450900'),(2147,'450981','北流市','450900'),(2148,'451001','市辖区','451000'),(2149,'451002','右江区','451000'),(2150,'451021','田阳县','451000'),(2151,'451022','田东县','451000'),(2152,'451023','平果县','451000'),(2153,'451024','德保县','451000'),(2154,'451025','靖西县','451000'),(2155,'451026','那坡县','451000'),(2156,'451027','凌云县','451000'),(2157,'451028','乐业县','451000'),(2158,'451029','田林县','451000'),(2159,'451030','西林县','451000'),(2160,'451031','隆林各族自治县','451000'),(2161,'451101','市辖区','451100'),(2162,'451102','八步区','451100'),(2163,'451121','昭平县','451100'),(2164,'451122','钟山县','451100'),(2165,'451123','富川瑶族自治县','451100'),(2166,'451201','市辖区','451200'),(2167,'451202','金城江区','451200'),(2168,'451221','南丹县','451200'),(2169,'451222','天峨县','451200'),(2170,'451223','凤山县','451200'),(2171,'451224','东兰县','451200'),(2172,'451225','罗城仫佬族自治县','451200'),(2173,'451226','环江毛南族自治县','451200'),(2174,'451227','巴马瑶族自治县','451200'),(2175,'451228','都安瑶族自治县','451200'),(2176,'451229','大化瑶族自治县','451200'),(2177,'451281','宜州市','451200'),(2178,'451301','市辖区','451300'),(2179,'451302','兴宾区','451300'),(2180,'451321','忻城县','451300'),(2181,'451322','象州县','451300'),(2182,'451323','武宣县','451300'),(2183,'451324','金秀瑶族自治县','451300'),(2184,'451381','合山市','451300'),(2185,'451401','市辖区','451400'),(2186,'451402','江洲区','451400'),(2187,'451421','扶绥县','451400'),(2188,'451422','宁明县','451400'),(2189,'451423','龙州县','451400'),(2190,'451424','大新县','451400'),(2191,'451425','天等县','451400'),(2192,'451481','凭祥市','451400'),(2193,'460101','市辖区','460100'),(2194,'460105','秀英区','460100'),(2195,'460106','龙华区','460100'),(2196,'460107','琼山区','460100'),(2197,'460108','美兰区','460100'),(2198,'460201','市辖区','460200'),(2199,'469001','五指山市','469000'),(2200,'469002','琼海市','469000'),(2201,'469003','儋州市','469000'),(2202,'469005','文昌市','469000'),(2203,'469006','万宁市','469000'),(2204,'469007','东方市','469000'),(2205,'469025','定安县','469000'),(2206,'469026','屯昌县','469000'),(2207,'469027','澄迈县','469000'),(2208,'469028','临高县','469000'),(2209,'469030','白沙黎族自治县','469000'),(2210,'469031','昌江黎族自治县','469000'),(2211,'469033','乐东黎族自治县','469000'),(2212,'469034','陵水黎族自治县','469000'),(2213,'469035','保亭黎族苗族自治县','469000'),(2214,'469036','琼中黎族苗族自治县','469000'),(2215,'469037','西沙群岛','469000'),(2216,'469038','南沙群岛','469000'),(2217,'469039','中沙群岛的岛礁及其海域','469000'),(2218,'500101','万州区','500100'),(2219,'500102','涪陵区','500100'),(2220,'500103','渝中区','500100'),(2221,'500104','大渡口区','500100'),(2222,'500105','江北区','500100'),(2223,'500106','沙坪坝区','500100'),(2224,'500107','九龙坡区','500100'),(2225,'500108','南岸区','500100'),(2226,'500109','北碚区','500100'),(2227,'500110','万盛区','500100'),(2228,'500111','双桥区','500100'),(2229,'500112','渝北区','500100'),(2230,'500113','巴南区','500100'),(2231,'500114','黔江区','500100'),(2232,'500115','长寿区','500100'),(2233,'500222','綦江县','500200'),(2234,'500223','潼南县','500200'),(2235,'500224','铜梁县','500200'),(2236,'500225','大足县','500200'),(2237,'500226','荣昌县','500200'),(2238,'500227','璧山县','500200'),(2239,'500228','梁平县','500200'),(2240,'500229','城口县','500200'),(2241,'500230','丰都县','500200'),(2242,'500231','垫江县','500200'),(2243,'500232','武隆县','500200'),(2244,'500233','忠　县','500200'),(2245,'500234','开　县','500200'),(2246,'500235','云阳县','500200'),(2247,'500236','奉节县','500200'),(2248,'500237','巫山县','500200'),(2249,'500238','巫溪县','500200'),(2250,'500240','石柱土家族自治县','500200'),(2251,'500241','秀山土家族苗族自治县','500200'),(2252,'500242','酉阳土家族苗族自治县','500200'),(2253,'500243','彭水苗族土家族自治县','500200'),(2254,'500381','江津市','500300'),(2255,'500382','合川市','500300'),(2256,'500383','永川市','500300'),(2257,'500384','南川市','500300'),(2258,'510101','市辖区','510100'),(2259,'510104','锦江区','510100'),(2260,'510105','青羊区','510100'),(2261,'510106','金牛区','510100'),(2262,'510107','武侯区','510100'),(2263,'510108','成华区','510100'),(2264,'510112','龙泉驿区','510100'),(2265,'510113','青白江区','510100'),(2266,'510114','新都区','510100'),(2267,'510115','温江县','510100'),(2268,'510121','金堂县','510100'),(2269,'510122','双流县','510100'),(2270,'510124','郫　县','510100'),(2271,'510129','大邑县','510100'),(2272,'510131','蒲江县','510100'),(2273,'510132','新津县','510100'),(2274,'510181','都江堰市','510100'),(2275,'510182','彭州市','510100'),(2276,'510183','邛崃市','510100'),(2277,'510184','崇州市','510100'),(2278,'510301','市辖区','510300'),(2279,'510302','自流井区','510300'),(2280,'510303','贡井区','510300'),(2281,'510304','大安区','510300'),(2282,'510311','沿滩区','510300'),(2283,'510321','荣　县','510300'),(2284,'510322','富顺县','510300'),(2285,'510401','市辖区','510400'),(2286,'510402','东　区','510400'),(2287,'510403','西　区','510400'),(2288,'510411','仁和区','510400'),(2289,'510421','米易县','510400'),(2290,'510422','盐边县','510400'),(2291,'510501','市辖区','510500'),(2292,'510502','江阳区','510500'),(2293,'510503','纳溪区','510500'),(2294,'510504','龙马潭区','510500'),(2295,'510521','泸　县','510500'),(2296,'510522','合江县','510500'),(2297,'510524','叙永县','510500'),(2298,'510525','古蔺县','510500'),(2299,'510601','市辖区','510600'),(2300,'510603','旌阳区','510600'),(2301,'510623','中江县','510600'),(2302,'510626','罗江县','510600'),(2303,'510681','广汉市','510600'),(2304,'510682','什邡市','510600'),(2305,'510683','绵竹市','510600'),(2306,'510701','市辖区','510700'),(2307,'510703','涪城区','510700'),(2308,'510704','游仙区','510700'),(2309,'510722','三台县','510700'),(2310,'510723','盐亭县','510700'),(2311,'510724','安　县','510700'),(2312,'510725','梓潼县','510700'),(2313,'510726','北川羌族自治县','510700'),(2314,'510727','平武县','510700'),(2315,'510781','江油市','510700'),(2316,'510801','市辖区','510800'),(2317,'510802','市中区','510800'),(2318,'510811','元坝区','510800'),(2319,'510812','朝天区','510800'),(2320,'510821','旺苍县','510800'),(2321,'510822','青川县','510800'),(2322,'510823','剑阁县','510800'),(2323,'510824','苍溪县','510800'),(2324,'510901','市辖区','510900'),(2325,'510903','船山区','510900'),(2326,'510904','安居区','510900'),(2327,'510921','蓬溪县','510900'),(2328,'510922','射洪县','510900'),(2329,'510923','大英县','510900'),(2330,'511001','市辖区','511000'),(2331,'511002','市中区','511000'),(2332,'511011','东兴区','511000'),(2333,'511024','威远县','511000'),(2334,'511025','资中县','511000'),(2335,'511028','隆昌县','511000'),(2336,'511101','市辖区','511100'),(2337,'511102','市中区','511100'),(2338,'511111','沙湾区','511100'),(2339,'511112','五通桥区','511100'),(2340,'511113','金口河区','511100'),(2341,'511123','犍为县','511100'),(2342,'511124','井研县','511100'),(2343,'511126','夹江县','511100'),(2344,'511129','沐川县','511100'),(2345,'511132','峨边彝族自治县','511100'),(2346,'511133','马边彝族自治县','511100'),(2347,'511181','峨眉山市','511100'),(2348,'511301','市辖区','511300'),(2349,'511302','顺庆区','511300'),(2350,'511303','高坪区','511300'),(2351,'511304','嘉陵区','511300'),(2352,'511321','南部县','511300'),(2353,'511322','营山县','511300'),(2354,'511323','蓬安县','511300'),(2355,'511324','仪陇县','511300'),(2356,'511325','西充县','511300'),(2357,'511381','阆中市','511300'),(2358,'511401','市辖区','511400'),(2359,'511402','东坡区','511400'),(2360,'511421','仁寿县','511400'),(2361,'511422','彭山县','511400'),(2362,'511423','洪雅县','511400'),(2363,'511424','丹棱县','511400'),(2364,'511425','青神县','511400'),(2365,'511501','市辖区','511500'),(2366,'511502','翠屏区','511500'),(2367,'511521','宜宾县','511500'),(2368,'511522','南溪县','511500'),(2369,'511523','江安县','511500'),(2370,'511524','长宁县','511500'),(2371,'511525','高　县','511500'),(2372,'511526','珙　县','511500'),(2373,'511527','筠连县','511500'),(2374,'511528','兴文县','511500'),(2375,'511529','屏山县','511500'),(2376,'511601','市辖区','511600'),(2377,'511602','广安区','511600'),(2378,'511621','岳池县','511600'),(2379,'511622','武胜县','511600'),(2380,'511623','邻水县','511600'),(2381,'511681','华莹市','511600'),(2382,'511701','市辖区','511700'),(2383,'511702','通川区','511700'),(2384,'511721','达　县','511700'),(2385,'511722','宣汉县','511700'),(2386,'511723','开江县','511700'),(2387,'511724','大竹县','511700'),(2388,'511725','渠　县','511700'),(2389,'511781','万源市','511700'),(2390,'511801','市辖区','511800'),(2391,'511802','雨城区','511800'),(2392,'511821','名山县','511800'),(2393,'511822','荥经县','511800'),(2394,'511823','汉源县','511800'),(2395,'511824','石棉县','511800'),(2396,'511825','天全县','511800'),(2397,'511826','芦山县','511800'),(2398,'511827','宝兴县','511800'),(2399,'511901','市辖区','511900'),(2400,'511902','巴州区','511900'),(2401,'511921','通江县','511900'),(2402,'511922','南江县','511900'),(2403,'511923','平昌县','511900'),(2404,'512001','市辖区','512000'),(2405,'512002','雁江区','512000'),(2406,'512021','安岳县','512000'),(2407,'512022','乐至县','512000'),(2408,'512081','简阳市','512000'),(2409,'513221','汶川县','513200'),(2410,'513222','理　县','513200'),(2411,'513223','茂　县','513200'),(2412,'513224','松潘县','513200'),(2413,'513225','九寨沟县','513200'),(2414,'513226','金川县','513200'),(2415,'513227','小金县','513200'),(2416,'513228','黑水县','513200'),(2417,'513229','马尔康县','513200'),(2418,'513230','壤塘县','513200'),(2419,'513231','阿坝县','513200'),(2420,'513232','若尔盖县','513200'),(2421,'513233','红原县','513200'),(2422,'513321','康定县','513300'),(2423,'513322','泸定县','513300'),(2424,'513323','丹巴县','513300'),(2425,'513324','九龙县','513300'),(2426,'513325','雅江县','513300'),(2427,'513326','道孚县','513300'),(2428,'513327','炉霍县','513300'),(2429,'513328','甘孜县','513300'),(2430,'513329','新龙县','513300'),(2431,'513330','德格县','513300'),(2432,'513331','白玉县','513300'),(2433,'513332','石渠县','513300'),(2434,'513333','色达县','513300'),(2435,'513334','理塘县','513300'),(2436,'513335','巴塘县','513300'),(2437,'513336','乡城县','513300'),(2438,'513337','稻城县','513300'),(2439,'513338','得荣县','513300'),(2440,'513401','西昌市','513400'),(2441,'513422','木里藏族自治县','513400'),(2442,'513423','盐源县','513400'),(2443,'513424','德昌县','513400'),(2444,'513425','会理县','513400'),(2445,'513426','会东县','513400'),(2446,'513427','宁南县','513400'),(2447,'513428','普格县','513400'),(2448,'513429','布拖县','513400'),(2449,'513430','金阳县','513400'),(2450,'513431','昭觉县','513400'),(2451,'513432','喜德县','513400'),(2452,'513433','冕宁县','513400'),(2453,'513434','越西县','513400'),(2454,'513435','甘洛县','513400'),(2455,'513436','美姑县','513400'),(2456,'513437','雷波县','513400'),(2457,'520101','市辖区','520100'),(2458,'520102','南明区','520100'),(2459,'520103','云岩区','520100'),(2460,'520111','花溪区','520100'),(2461,'520112','乌当区','520100'),(2462,'520113','白云区','520100'),(2463,'520114','小河区','520100'),(2464,'520121','开阳县','520100'),(2465,'520122','息烽县','520100'),(2466,'520123','修文县','520100'),(2467,'520181','清镇市','520100'),(2468,'520201','钟山区','520200'),(2469,'520203','六枝特区','520200'),(2470,'520221','水城县','520200'),(2471,'520222','盘　县','520200'),(2472,'520301','市辖区','520300'),(2473,'520302','红花岗区','520300'),(2474,'520303','汇川区','520300'),(2475,'520321','遵义县','520300'),(2476,'520322','桐梓县','520300'),(2477,'520323','绥阳县','520300'),(2478,'520324','正安县','520300'),(2479,'520325','道真仡佬族苗族自治县','520300'),(2480,'520326','务川仡佬族苗族自治县','520300'),(2481,'520327','凤冈县','520300'),(2482,'520328','湄潭县','520300'),(2483,'520329','余庆县','520300'),(2484,'520330','习水县','520300'),(2485,'520381','赤水市','520300'),(2486,'520382','仁怀市','520300'),(2487,'520401','市辖区','520400'),(2488,'520402','西秀区','520400'),(2489,'520421','平坝县','520400'),(2490,'520422','普定县','520400'),(2491,'520423','镇宁布依族苗族自治县','520400'),(2492,'520424','关岭布依族苗族自治县','520400'),(2493,'520425','紫云苗族布依族自治县','520400'),(2494,'522201','铜仁市','522200'),(2495,'522222','江口县','522200'),(2496,'522223','玉屏侗族自治县','522200'),(2497,'522224','石阡县','522200'),(2498,'522225','思南县','522200'),(2499,'522226','印江土家族苗族自治县','522200'),(2500,'522227','德江县','522200'),(2501,'522228','沿河土家族自治县','522200'),(2502,'522229','松桃苗族自治县','522200'),(2503,'522230','万山特区','522200'),(2504,'522301','兴义市','522300'),(2505,'522322','兴仁县','522300'),(2506,'522323','普安县','522300'),(2507,'522324','晴隆县','522300'),(2508,'522325','贞丰县','522300'),(2509,'522326','望谟县','522300'),(2510,'522327','册亨县','522300'),(2511,'522328','安龙县','522300'),(2512,'522401','毕节市','522400'),(2513,'522422','大方县','522400'),(2514,'522423','黔西县','522400'),(2515,'522424','金沙县','522400'),(2516,'522425','织金县','522400'),(2517,'522426','纳雍县','522400'),(2518,'522427','威宁彝族回族苗族自治县','522400'),(2519,'522428','赫章县','522400'),(2520,'522601','凯里市','522600'),(2521,'522622','黄平县','522600'),(2522,'522623','施秉县','522600'),(2523,'522624','三穗县','522600'),(2524,'522625','镇远县','522600'),(2525,'522626','岑巩县','522600'),(2526,'522627','天柱县','522600'),(2527,'522628','锦屏县','522600'),(2528,'522629','剑河县','522600'),(2529,'522630','台江县','522600'),(2530,'522631','黎平县','522600'),(2531,'522632','榕江县','522600'),(2532,'522633','从江县','522600'),(2533,'522634','雷山县','522600'),(2534,'522635','麻江县','522600'),(2535,'522636','丹寨县','522600'),(2536,'522701','都匀市','522700'),(2537,'522702','福泉市','522700'),(2538,'522722','荔波县','522700'),(2539,'522723','贵定县','522700'),(2540,'522725','瓮安县','522700'),(2541,'522726','独山县','522700'),(2542,'522727','平塘县','522700'),(2543,'522728','罗甸县','522700'),(2544,'522729','长顺县','522700'),(2545,'522730','龙里县','522700'),(2546,'522731','惠水县','522700'),(2547,'522732','三都水族自治县','522700'),(2548,'530101','市辖区','530100'),(2549,'530102','五华区','530100'),(2550,'530103','盘龙区','530100'),(2551,'530111','官渡区','530100'),(2552,'530112','西山区','530100'),(2553,'530113','东川区','530100'),(2554,'530121','呈贡县','530100'),(2555,'530122','晋宁县','530100'),(2556,'530124','富民县','530100'),(2557,'530125','宜良县','530100'),(2558,'530126','石林彝族自治县','530100'),(2559,'530127','嵩明县','530100'),(2560,'530128','禄劝彝族苗族自治县','530100'),(2561,'530129','寻甸回族彝族自治县','530100'),(2562,'530181','安宁市','530100'),(2563,'530301','市辖区','530300'),(2564,'530302','麒麟区','530300'),(2565,'530321','马龙县','530300'),(2566,'530322','陆良县','530300'),(2567,'530323','师宗县','530300'),(2568,'530324','罗平县','530300'),(2569,'530325','富源县','530300'),(2570,'530326','会泽县','530300'),(2571,'530328','沾益县','530300'),(2572,'530381','宣威市','530300'),(2573,'530401','市辖区','530400'),(2574,'530402','红塔区','530400'),(2575,'530421','江川县','530400'),(2576,'530422','澄江县','530400'),(2577,'530423','通海县','530400'),(2578,'530424','华宁县','530400'),(2579,'530425','易门县','530400'),(2580,'530426','峨山彝族自治县','530400'),(2581,'530427','新平彝族傣族自治县','530400'),(2582,'530428','元江哈尼族彝族傣族自治县','530400'),(2583,'530501','市辖区','530500'),(2584,'530502','隆阳区','530500'),(2585,'530521','施甸县','530500'),(2586,'530522','腾冲县','530500'),(2587,'530523','龙陵县','530500'),(2588,'530524','昌宁县','530500'),(2589,'530601','市辖区','530600'),(2590,'530602','昭阳区','530600'),(2591,'530621','鲁甸县','530600'),(2592,'530622','巧家县','530600'),(2593,'530623','盐津县','530600'),(2594,'530624','大关县','530600'),(2595,'530625','永善县','530600'),(2596,'530626','绥江县','530600'),(2597,'530627','镇雄县','530600'),(2598,'530628','彝良县','530600'),(2599,'530629','威信县','530600'),(2600,'530630','水富县','530600'),(2601,'530701','市辖区','530700'),(2602,'530702','古城区','530700'),(2603,'530721','玉龙纳西族自治县','530700'),(2604,'530722','永胜县','530700'),(2605,'530723','华坪县','530700'),(2606,'530724','宁蒗彝族自治县','530700'),(2607,'530801','市辖区','530800'),(2608,'530802','翠云区','530800'),(2609,'530821','普洱哈尼族彝族自治县','530800'),(2610,'530822','墨江哈尼族自治县','530800'),(2611,'530823','景东彝族自治县','530800'),(2612,'530824','景谷傣族彝族自治县','530800'),(2613,'530825','镇沅彝族哈尼族拉祜族自治县','530800'),(2614,'530826','江城哈尼族彝族自治县','530800'),(2615,'530827','孟连傣族拉祜族佤族自治县','530800'),(2616,'530828','澜沧拉祜族自治县','530800'),(2617,'530829','西盟佤族自治县','530800'),(2618,'530901','市辖区','530900'),(2619,'530902','临翔区','530900'),(2620,'530921','凤庆县','530900'),(2621,'530922','云　县','530900'),(2622,'530923','永德县','530900'),(2623,'530924','镇康县','530900'),(2624,'530925','双江拉祜族佤族布朗族傣族自治县','530900'),(2625,'530926','耿马傣族佤族自治县','530900'),(2626,'530927','沧源佤族自治县','530900'),(2627,'532301','楚雄市','532300'),(2628,'532322','双柏县','532300'),(2629,'532323','牟定县','532300'),(2630,'532324','南华县','532300'),(2631,'532325','姚安县','532300'),(2632,'532326','大姚县','532300'),(2633,'532327','永仁县','532300'),(2634,'532328','元谋县','532300'),(2635,'532329','武定县','532300'),(2636,'532331','禄丰县','532300'),(2637,'532501','个旧市','532500'),(2638,'532502','开远市','532500'),(2639,'532522','蒙自县','532500'),(2640,'532523','屏边苗族自治县','532500'),(2641,'532524','建水县','532500'),(2642,'532525','石屏县','532500'),(2643,'532526','弥勒县','532500'),(2644,'532527','泸西县','532500'),(2645,'532528','元阳县','532500'),(2646,'532529','红河县','532500'),(2647,'532530','金平苗族瑶族傣族自治县','532500'),(2648,'532531','绿春县','532500'),(2649,'532532','河口瑶族自治县','532500'),(2650,'532621','文山县','532600'),(2651,'532622','砚山县','532600'),(2652,'532623','西畴县','532600'),(2653,'532624','麻栗坡县','532600'),(2654,'532625','马关县','532600'),(2655,'532626','丘北县','532600'),(2656,'532627','广南县','532600'),(2657,'532628','富宁县','532600'),(2658,'532801','景洪市','532800'),(2659,'532822','勐海县','532800'),(2660,'532823','勐腊县','532800'),(2661,'532901','大理市','532900'),(2662,'532922','漾濞彝族自治县','532900'),(2663,'532923','祥云县','532900'),(2664,'532924','宾川县','532900'),(2665,'532925','弥渡县','532900'),(2666,'532926','南涧彝族自治县','532900'),(2667,'532927','巍山彝族回族自治县','532900'),(2668,'532928','永平县','532900'),(2669,'532929','云龙县','532900'),(2670,'532930','洱源县','532900'),(2671,'532931','剑川县','532900'),(2672,'532932','鹤庆县','532900'),(2673,'533102','瑞丽市','533100'),(2674,'533103','潞西市','533100'),(2675,'533122','梁河县','533100'),(2676,'533123','盈江县','533100'),(2677,'533124','陇川县','533100'),(2678,'533321','泸水县','533300'),(2679,'533323','福贡县','533300'),(2680,'533324','贡山独龙族怒族自治县','533300'),(2681,'533325','兰坪白族普米族自治县','533300'),(2682,'533421','香格里拉县','533400'),(2683,'533422','德钦县','533400'),(2684,'533423','维西傈僳族自治县','533400'),(2685,'540101','市辖区','540100'),(2686,'540102','城关区','540100'),(2687,'540121','林周县','540100'),(2688,'540122','当雄县','540100'),(2689,'540123','尼木县','540100'),(2690,'540124','曲水县','540100'),(2691,'540125','堆龙德庆县','540100'),(2692,'540126','达孜县','540100'),(2693,'540127','墨竹工卡县','540100'),(2694,'542121','昌都县','542100'),(2695,'542122','江达县','542100'),(2696,'542123','贡觉县','542100'),(2697,'542124','类乌齐县','542100'),(2698,'542125','丁青县','542100'),(2699,'542126','察雅县','542100'),(2700,'542127','八宿县','542100'),(2701,'542128','左贡县','542100'),(2702,'542129','芒康县','542100'),(2703,'542132','洛隆县','542100'),(2704,'542133','边坝县','542100'),(2705,'542221','乃东县','542200'),(2706,'542222','扎囊县','542200'),(2707,'542223','贡嘎县','542200'),(2708,'542224','桑日县','542200'),(2709,'542225','琼结县','542200'),(2710,'542226','曲松县','542200'),(2711,'542227','措美县','542200'),(2712,'542228','洛扎县','542200'),(2713,'542229','加查县','542200'),(2714,'542231','隆子县','542200'),(2715,'542232','错那县','542200'),(2716,'542233','浪卡子县','542200'),(2717,'542301','日喀则市','542300'),(2718,'542322','南木林县','542300'),(2719,'542323','江孜县','542300'),(2720,'542324','定日县','542300'),(2721,'542325','萨迦县','542300'),(2722,'542326','拉孜县','542300'),(2723,'542327','昂仁县','542300'),(2724,'542328','谢通门县','542300'),(2725,'542329','白朗县','542300'),(2726,'542330','仁布县','542300'),(2727,'542331','康马县','542300'),(2728,'542332','定结县','542300'),(2729,'542333','仲巴县','542300'),(2730,'542334','亚东县','542300'),(2731,'542335','吉隆县','542300'),(2732,'542336','聂拉木县','542300'),(2733,'542337','萨嘎县','542300'),(2734,'542338','岗巴县','542300'),(2735,'542421','那曲县','542400'),(2736,'542422','嘉黎县','542400'),(2737,'542423','比如县','542400'),(2738,'542424','聂荣县','542400'),(2739,'542425','安多县','542400'),(2740,'542426','申扎县','542400'),(2741,'542427','索　县','542400'),(2742,'542428','班戈县','542400'),(2743,'542429','巴青县','542400'),(2744,'542430','尼玛县','542400'),(2745,'542521','普兰县','542500'),(2746,'542522','札达县','542500'),(2747,'542523','噶尔县','542500'),(2748,'542524','日土县','542500'),(2749,'542525','革吉县','542500'),(2750,'542526','改则县','542500'),(2751,'542527','措勤县','542500'),(2752,'542621','林芝县','542600'),(2753,'542622','工布江达县','542600'),(2754,'542623','米林县','542600'),(2755,'542624','墨脱县','542600'),(2756,'542625','波密县','542600'),(2757,'542626','察隅县','542600'),(2758,'542627','朗　县','542600'),(2759,'610101','市辖区','610100'),(2760,'610102','新城区','610100'),(2761,'610103','碑林区','610100'),(2762,'610104','莲湖区','610100'),(2763,'610111','灞桥区','610100'),(2764,'610112','未央区','610100'),(2765,'610113','雁塔区','610100'),(2766,'610114','阎良区','610100'),(2767,'610115','临潼区','610100'),(2768,'610116','长安区','610100'),(2769,'610122','蓝田县','610100'),(2770,'610124','周至县','610100'),(2771,'610125','户　县','610100'),(2772,'610126','高陵县','610100'),(2773,'610201','市辖区','610200'),(2774,'610202','王益区','610200'),(2775,'610203','印台区','610200'),(2776,'610204','耀州区','610200'),(2777,'610222','宜君县','610200'),(2778,'610301','市辖区','610300'),(2779,'610302','渭滨区','610300'),(2780,'610303','金台区','610300'),(2781,'610304','陈仓区','610300'),(2782,'610322','凤翔县','610300'),(2783,'610323','岐山县','610300'),(2784,'610324','扶风县','610300'),(2785,'610326','眉　县','610300'),(2786,'610327','陇　县','610300'),(2787,'610328','千阳县','610300'),(2788,'610329','麟游县','610300'),(2789,'610330','凤　县','610300'),(2790,'610331','太白县','610300'),(2791,'610401','市辖区','610400'),(2792,'610402','秦都区','610400'),(2793,'610403','杨凌区','610400'),(2794,'610404','渭城区','610400'),(2795,'610422','三原县','610400'),(2796,'610423','泾阳县','610400'),(2797,'610424','乾　县','610400'),(2798,'610425','礼泉县','610400'),(2799,'610426','永寿县','610400'),(2800,'610427','彬　县','610400'),(2801,'610428','长武县','610400'),(2802,'610429','旬邑县','610400'),(2803,'610430','淳化县','610400'),(2804,'610431','武功县','610400'),(2805,'610481','兴平市','610400'),(2806,'610501','市辖区','610500'),(2807,'610502','临渭区','610500'),(2808,'610521','华　县','610500'),(2809,'610522','潼关县','610500'),(2810,'610523','大荔县','610500'),(2811,'610524','合阳县','610500'),(2812,'610525','澄城县','610500'),(2813,'610526','蒲城县','610500'),(2814,'610527','白水县','610500'),(2815,'610528','富平县','610500'),(2816,'610581','韩城市','610500'),(2817,'610582','华阴市','610500'),(2818,'610601','市辖区','610600'),(2819,'610602','宝塔区','610600'),(2820,'610621','延长县','610600'),(2821,'610622','延川县','610600'),(2822,'610623','子长县','610600'),(2823,'610624','安塞县','610600'),(2824,'610625','志丹县','610600'),(2825,'610626','吴旗县','610600'),(2826,'610627','甘泉县','610600'),(2827,'610628','富　县','610600'),(2828,'610629','洛川县','610600'),(2829,'610630','宜川县','610600'),(2830,'610631','黄龙县','610600'),(2831,'610632','黄陵县','610600'),(2832,'610701','市辖区','610700'),(2833,'610702','汉台区','610700'),(2834,'610721','南郑县','610700'),(2835,'610722','城固县','610700'),(2836,'610723','洋　县','610700'),(2837,'610724','西乡县','610700'),(2838,'610725','勉　县','610700'),(2839,'610726','宁强县','610700'),(2840,'610727','略阳县','610700'),(2841,'610728','镇巴县','610700'),(2842,'610729','留坝县','610700'),(2843,'610730','佛坪县','610700'),(2844,'610801','市辖区','610800'),(2845,'610802','榆阳区','610800'),(2846,'610821','神木县','610800'),(2847,'610822','府谷县','610800'),(2848,'610823','横山县','610800'),(2849,'610824','靖边县','610800'),(2850,'610825','定边县','610800'),(2851,'610826','绥德县','610800'),(2852,'610827','米脂县','610800'),(2853,'610828','佳　县','610800'),(2854,'610829','吴堡县','610800'),(2855,'610830','清涧县','610800'),(2856,'610831','子洲县','610800'),(2857,'610901','市辖区','610900'),(2858,'610902','汉滨区','610900'),(2859,'610921','汉阴县','610900'),(2860,'610922','石泉县','610900'),(2861,'610923','宁陕县','610900'),(2862,'610924','紫阳县','610900'),(2863,'610925','岚皋县','610900'),(2864,'610926','平利县','610900'),(2865,'610927','镇坪县','610900'),(2866,'610928','旬阳县','610900'),(2867,'610929','白河县','610900'),(2868,'611001','市辖区','611000'),(2869,'611002','商州区','611000'),(2870,'611021','洛南县','611000'),(2871,'611022','丹凤县','611000'),(2872,'611023','商南县','611000'),(2873,'611024','山阳县','611000'),(2874,'611025','镇安县','611000'),(2875,'611026','柞水县','611000'),(2876,'620101','市辖区','620100'),(2877,'620102','城关区','620100'),(2878,'620103','七里河区','620100'),(2879,'620104','西固区','620100'),(2880,'620105','安宁区','620100'),(2881,'620111','红古区','620100'),(2882,'620121','永登县','620100'),(2883,'620122','皋兰县','620100'),(2884,'620123','榆中县','620100'),(2885,'620201','市辖区','620200'),(2886,'620301','市辖区','620300'),(2887,'620302','金川区','620300'),(2888,'620321','永昌县','620300'),(2889,'620401','市辖区','620400'),(2890,'620402','白银区','620400'),(2891,'620403','平川区','620400'),(2892,'620421','靖远县','620400'),(2893,'620422','会宁县','620400'),(2894,'620423','景泰县','620400'),(2895,'620501','市辖区','620500'),(2896,'620502','秦城区','620500'),(2897,'620503','北道区','620500'),(2898,'620521','清水县','620500'),(2899,'620522','秦安县','620500'),(2900,'620523','甘谷县','620500'),(2901,'620524','武山县','620500'),(2902,'620525','张家川回族自治县','620500'),(2903,'620601','市辖区','620600'),(2904,'620602','凉州区','620600'),(2905,'620621','民勤县','620600'),(2906,'620622','古浪县','620600'),(2907,'620623','天祝藏族自治县','620600'),(2908,'620701','市辖区','620700'),(2909,'620702','甘州区','620700'),(2910,'620721','肃南裕固族自治县','620700'),(2911,'620722','民乐县','620700'),(2912,'620723','临泽县','620700'),(2913,'620724','高台县','620700'),(2914,'620725','山丹县','620700'),(2915,'620801','市辖区','620800'),(2916,'620802','崆峒区','620800'),(2917,'620821','泾川县','620800'),(2918,'620822','灵台县','620800'),(2919,'620823','崇信县','620800'),(2920,'620824','华亭县','620800'),(2921,'620825','庄浪县','620800'),(2922,'620826','静宁县','620800'),(2923,'620901','市辖区','620900'),(2924,'620902','肃州区','620900'),(2925,'620921','金塔县','620900'),(2926,'620922','安西县','620900'),(2927,'620923','肃北蒙古族自治县','620900'),(2928,'620924','阿克塞哈萨克族自治县','620900'),(2929,'620981','玉门市','620900'),(2930,'620982','敦煌市','620900'),(2931,'621001','市辖区','621000'),(2932,'621002','西峰区','621000'),(2933,'621021','庆城县','621000'),(2934,'621022','环　县','621000'),(2935,'621023','华池县','621000'),(2936,'621024','合水县','621000'),(2937,'621025','正宁县','621000'),(2938,'621026','宁　县','621000'),(2939,'621027','镇原县','621000'),(2940,'621101','市辖区','621100'),(2941,'621102','安定区','621100'),(2942,'621121','通渭县','621100'),(2943,'621122','陇西县','621100'),(2944,'621123','渭源县','621100'),(2945,'621124','临洮县','621100'),(2946,'621125','漳　县','621100'),(2947,'621126','岷　县','621100'),(2948,'621201','市辖区','621200'),(2949,'621202','武都区','621200'),(2950,'621221','成　县','621200'),(2951,'621222','文　县','621200'),(2952,'621223','宕昌县','621200'),(2953,'621224','康　县','621200'),(2954,'621225','西和县','621200'),(2955,'621226','礼　县','621200'),(2956,'621227','徽　县','621200'),(2957,'621228','两当县','621200'),(2958,'622901','临夏市','622900'),(2959,'622921','临夏县','622900'),(2960,'622922','康乐县','622900'),(2961,'622923','永靖县','622900'),(2962,'622924','广河县','622900'),(2963,'622925','和政县','622900'),(2964,'622926','东乡族自治县','622900'),(2965,'622927','积石山保安族东乡族撒拉族自治县','622900'),(2966,'623001','合作市','623000'),(2967,'623021','临潭县','623000'),(2968,'623022','卓尼县','623000'),(2969,'623023','舟曲县','623000'),(2970,'623024','迭部县','623000'),(2971,'623025','玛曲县','623000'),(2972,'623026','碌曲县','623000'),(2973,'623027','夏河县','623000'),(2974,'630101','市辖区','630100'),(2975,'630102','城东区','630100'),(2976,'630103','城中区','630100'),(2977,'630104','城西区','630100'),(2978,'630105','城北区','630100'),(2979,'630121','大通回族土族自治县','630100'),(2980,'630122','湟中县','630100'),(2981,'630123','湟源县','630100'),(2982,'632121','平安县','632100'),(2983,'632122','民和回族土族自治县','632100'),(2984,'632123','乐都县','632100'),(2985,'632126','互助土族自治县','632100'),(2986,'632127','化隆回族自治县','632100'),(2987,'632128','循化撒拉族自治县','632100'),(2988,'632221','门源回族自治县','632200'),(2989,'632222','祁连县','632200'),(2990,'632223','海晏县','632200'),(2991,'632224','刚察县','632200'),(2992,'632321','同仁县','632300'),(2993,'632322','尖扎县','632300'),(2994,'632323','泽库县','632300'),(2995,'632324','河南蒙古族自治县','632300'),(2996,'632521','共和县','632500'),(2997,'632522','同德县','632500'),(2998,'632523','贵德县','632500'),(2999,'632524','兴海县','632500'),(3000,'632525','贵南县','632500'),(3001,'632621','玛沁县','632600'),(3002,'632622','班玛县','632600'),(3003,'632623','甘德县','632600'),(3004,'632624','达日县','632600'),(3005,'632625','久治县','632600'),(3006,'632626','玛多县','632600'),(3007,'632721','玉树县','632700'),(3008,'632722','杂多县','632700'),(3009,'632723','称多县','632700'),(3010,'632724','治多县','632700'),(3011,'632725','囊谦县','632700'),(3012,'632726','曲麻莱县','632700'),(3013,'632801','格尔木市','632800'),(3014,'632802','德令哈市','632800'),(3015,'632821','乌兰县','632800'),(3016,'632822','都兰县','632800'),(3017,'632823','天峻县','632800'),(3018,'640101','市辖区','640100'),(3019,'640104','兴庆区','640100'),(3020,'640105','西夏区','640100'),(3021,'640106','金凤区','640100'),(3022,'640121','永宁县','640100'),(3023,'640122','贺兰县','640100'),(3024,'640181','灵武市','640100'),(3025,'640201','市辖区','640200'),(3026,'640202','大武口区','640200'),(3027,'640205','惠农区','640200'),(3028,'640221','平罗县','640200'),(3029,'640301','市辖区','640300'),(3030,'640302','利通区','640300'),(3031,'640323','盐池县','640300'),(3032,'640324','同心县','640300'),(3033,'640381','青铜峡市','640300'),(3034,'640401','市辖区','640400'),(3035,'640402','原州区','640400'),(3036,'640422','西吉县','640400'),(3037,'640423','隆德县','640400'),(3038,'640424','泾源县','640400'),(3039,'640425','彭阳县','640400'),(3040,'640501','市辖区','640500'),(3041,'640502','沙坡头区','640500'),(3042,'640521','中宁县','640500'),(3043,'640522','海原县','640400'),(3044,'650101','市辖区','650100'),(3045,'650102','天山区','650100'),(3046,'650103','沙依巴克区','650100'),(3047,'650104','新市区','650100'),(3048,'650105','水磨沟区','650100'),(3049,'650106','头屯河区','650100'),(3050,'650107','达坂城区','650100'),(3051,'650108','东山区','650100'),(3052,'650121','乌鲁木齐县','650100'),(3053,'650201','市辖区','650200'),(3054,'650202','独山子区','650200'),(3055,'650203','克拉玛依区','650200'),(3056,'650204','白碱滩区','650200'),(3057,'650205','乌尔禾区','650200'),(3058,'652101','吐鲁番市','652100'),(3059,'652122','鄯善县','652100'),(3060,'652123','托克逊县','652100'),(3061,'652201','哈密市','652200'),(3062,'652222','巴里坤哈萨克自治县','652200'),(3063,'652223','伊吾县','652200'),(3064,'652301','昌吉市','652300'),(3065,'652302','阜康市','652300'),(3066,'652303','米泉市','652300'),(3067,'652323','呼图壁县','652300'),(3068,'652324','玛纳斯县','652300'),(3069,'652325','奇台县','652300'),(3070,'652327','吉木萨尔县','652300'),(3071,'652328','木垒哈萨克自治县','652300'),(3072,'652701','博乐市','652700'),(3073,'652722','精河县','652700'),(3074,'652723','温泉县','652700'),(3075,'652801','库尔勒市','652800'),(3076,'652822','轮台县','652800'),(3077,'652823','尉犁县','652800'),(3078,'652824','若羌县','652800'),(3079,'652825','且末县','652800'),(3080,'652826','焉耆回族自治县','652800'),(3081,'652827','和静县','652800'),(3082,'652828','和硕县','652800'),(3083,'652829','博湖县','652800'),(3084,'652901','阿克苏市','652900'),(3085,'652922','温宿县','652900'),(3086,'652923','库车县','652900'),(3087,'652924','沙雅县','652900'),(3088,'652925','新和县','652900'),(3089,'652926','拜城县','652900'),(3090,'652927','乌什县','652900'),(3091,'652928','阿瓦提县','652900'),(3092,'652929','柯坪县','652900'),(3093,'653001','阿图什市','653000'),(3094,'653022','阿克陶县','653000'),(3095,'653023','阿合奇县','653000'),(3096,'653024','乌恰县','653000'),(3097,'653101','喀什市','653100'),(3098,'653121','疏附县','653100'),(3099,'653122','疏勒县','653100'),(3100,'653123','英吉沙县','653100'),(3101,'653124','泽普县','653100'),(3102,'653125','莎车县','653100'),(3103,'653126','叶城县','653100'),(3104,'653127','麦盖提县','653100'),(3105,'653128','岳普湖县','653100'),(3106,'653129','伽师县','653100'),(3107,'653130','巴楚县','653100'),(3108,'653131','塔什库尔干塔吉克自治县','653100'),(3109,'653201','和田市','653200'),(3110,'653221','和田县','653200'),(3111,'653222','墨玉县','653200'),(3112,'653223','皮山县','653200'),(3113,'653224','洛浦县','653200'),(3114,'653225','策勒县','653200'),(3115,'653226','于田县','653200'),(3116,'653227','民丰县','653200'),(3117,'654002','伊宁市','654000'),(3118,'654003','奎屯市','654000'),(3119,'654021','伊宁县','654000'),(3120,'654022','察布查尔锡伯自治县','654000'),(3121,'654023','霍城县','654000'),(3122,'654024','巩留县','654000'),(3123,'654025','新源县','654000'),(3124,'654026','昭苏县','654000'),(3125,'654027','特克斯县','654000'),(3126,'654028','尼勒克县','654000'),(3127,'654201','塔城市','654200'),(3128,'654202','乌苏市','654200'),(3129,'654221','额敏县','654200'),(3130,'654223','沙湾县','654200'),(3131,'654224','托里县','654200'),(3132,'654225','裕民县','654200'),(3133,'654226','和布克赛尔蒙古自治县','654200'),(3134,'654301','阿勒泰市','654300'),(3135,'654321','布尔津县','654300'),(3136,'654322','富蕴县','654300'),(3137,'654323','福海县','654300'),(3138,'654324','哈巴河县','654300'),(3139,'654325','青河县','654300'),(3140,'654326','吉木乃县','654300'),(3141,'659001','石河子市','659000'),(3142,'659002','阿拉尔市','659000'),(3143,'659003','图木舒克市','659000'),(3144,'659004','五家渠市','659000');

INSERT INTO tb_user_address (id, user_id, province_id, city_id, town_id, mobile, address, contact, is_default, create_date, alias) VALUES (1,'java00001','110000','110100','110105','13900112222','金燕龙办公楼','李嘉诚','0','2022-01-02 10:26:50','公司'),(2,'java00001','110000','110100','110103','13700221122','修正大厦','李佳红','0','2022-01-02 10:26:50','公司'),(3,'java00001','110000','110100','110105','13301212233','中腾大厦','李佳星','0','2022-01-02 10:26:50','家里'),(4,'zhaoliu','110000','110100','110104','13301212235','西直门','赵三','1','2022-01-02 10:26:50','家里'),(5,'deng','110000','110100','110103','13301212238','永春武馆','李小龙','0','2022-01-02 10:26:50','家里'),(6,'deng','110000','110100','110102','13301212239','咏春武馆总部','叶问','1','2022-01-02 10:26:50','师爷家');

INSERT INTO tb_goods_base (id, seller_id, goods_name, audit_status, is_marketable, brand_id, caption, category1_id, category2_id, category3_id, small_pic, price, is_delete) VALUES (149187842867912,'yijia','华为手机','1','1',19,'打折促销中',558,559,560,NULL,3020.00,'0'),(149187842867913,'yijia','华为手机','1','1',19,'打折促销中',558,559,560,NULL,3020.00,'1'),(149187842867914,'yijia','华为手机','1','1',19,'打折促销中',558,559,560,NULL,3020.00,'1'),(149187842867915,'yijia','华为手机','2','1',19,'打折促销中',558,559,560,NULL,3020.00,'1'),(149187842867916,'yijia','华为手机','2','1',19,'打折促销中',558,559,560,NULL,3020.00,'1'),(149187842867917,'yijia','华为手机','0','1',19,'打折促销中',558,559,560,NULL,3020.00,'1'),(149187842867918,'yijia','华为手机','0','1',19,'打折促销中',558,559,560,NULL,3020.00,'1'),(149187842867919,'yijia','华为手机','0','1',19,'打折促销中',558,559,560,NULL,3020.00,'1'),(149187842867920,'yijia','华为手机','1','1',19,'打折促销中',558,559,560,NULL,3020.00,'0'),(149187842867921,'yijia','华为手机','0','1',19,'打折促销中',558,559,560,NULL,3020.00,'1'),(149187842867922,'yijia','华为手机','1','1',19,'打折促销中',558,559,560,NULL,3020.00,'0'),(149187842867923,'yijia','华为手机','1','1',19,'打折促销中',558,559,560,NULL,3020.00,'0'),(149187842867924,'yijia','华为手机','0','1',19,'打折促销中',558,559,560,NULL,3020.00,'1'),(149187842867925,'yijia','华为手机','0','1',19,'打折促销中',558,559,560,NULL,3020.00,'0'),(149187842867926,'yijia','华为手机','0','1',19,'打折促销中',558,559,560,NULL,3020.00,'0'),(149187842867927,'yijia','华为手机','0','1',19,'打折促销中',558,559,560,NULL,3020.00,'0'),(149187842867928,'yijia','华为手机','0','1',19,'打折促销中',558,559,560,NULL,3020.00,'0'),(149187842867929,'yijia','华为手机','0','1',19,'打折促销中',558,559,560,NULL,3020.00,'0'),(149187842867930,'yijia','三星手机','0','1',7,'三星手机火爆上市',558,559,560,NULL,1500.00,'0'),(149187842867931,'yijia','炫彩','1','1',7,'好产品',249,281,289,NULL,100.00,'0'),(149187842867932,'qiandu','小米手机','2','1',12,'就是抢不到',249,281,289,NULL,1389.00,'0'),(149187842867933,'qiandu','大米手机','2','1',12,'不是小米不知道',249,281,289,NULL,8888.00,'0'),(149187842867934,'qiandu','黄米手机','1','1',12,'不知道怎么样，买了就知道了',249,281,289,NULL,6666.00,'0'),(149187842867935,'qiandu','三星手机','1','1',7,'火爆上市',558,559,560,NULL,3000.00,'0'),(149187842867936,'qiandu','四星手机','1','1',7,'不曾火爆',558,559,560,NULL,1.00,'0'),(149187842867937,'qiandu','测试','2','1',3,'嗯嗯呃',378,386,389,NULL,19.00,'0'),(149187842867938,'qiandu','测试商品','2','1',5,'测试标题',438,486,490,NULL,100.00,'0');

INSERT INTO tb_goods_brand (id, name, letter, seq) VALUES (1,'HTC','H',1),(2,'LG','L',1),(3,'NEC','N',2),(4,'OPPO','O',3),(5,'TCL','T',2),(6,'爱贝多','A',3),(7,'三星','A',1),(8,'白金','B',8),(9,'波导','B',5),(10,'朵唯','D',6),(11,'飞利浦','F',7),(12,'富可视','F',NULL),(13,'富士通','F',NULL),(14,'格力','G',NULL),(15,'海尔','H',NULL),(16,'海信','H',NULL),(17,'黑莓','H',NULL),(18,'华硕','H',NULL),(19,'华为','H',NULL),(20,'惠普','H',NULL),(21,'金立','J',NULL),(22,'京瓷','J',NULL),(23,'康佳','K',NULL),(24,'酷派','K',NULL),(25,'联想','L',NULL),(26,'漫步者','M',NULL),(27,'魅族','M',NULL),(28,'摩托罗拉','M',NULL),(29,'诺基亚','N',NULL),(30,'Apple','A',NULL);

INSERT INTO tb_goods_cat (id, parent_id, name, type_id) VALUES (1,0,'图书、音像、电子书刊',35),(2,1,'电子书刊',35),(3,2,'电子书',35),(4,2,'网络原创',35),(5,2,'数字杂志',35),(6,2,'多媒体图书',35),(7,1,'音像',35),(8,7,'音乐',35),(9,7,'影视',35),(10,7,'教育音像',35),(11,1,'英文原版',35),(13,11,'商务投资',35),(14,11,'英语学习与考试',35),(16,11,'传记',35),(18,1,'文艺',35),(19,18,'小说',35),(20,18,'文学',35),(21,18,'青春文学',35),(22,18,'传记',35),(23,18,'艺术',35),(24,1,'少儿',35),(25,24,'少儿',35),(26,24,'0-2岁',35),(27,24,'3-6岁',35),(28,24,'7-10岁',35),(29,24,'11-14岁',35),(30,1,'人文社科',35),(31,30,'历史',35),(32,30,'哲学',35),(33,30,'国学',35),(34,30,'政治/军事',35),(35,30,'法律',35),(36,30,'宗教',35),(37,30,'心理学',35),(38,30,'文化',35),(39,30,'社会科学',35),(40,1,'经管励志',35),(41,40,'经济',35),(42,40,'金融与投资',35),(43,40,'管理',35),(44,40,'励志与成功',35),(45,1,'生活',35),(46,45,'生活',35),(47,45,'健身与保健',35),(48,45,'家庭与育儿',35),(49,45,'旅游',35),(50,45,'动漫/幽默',35),(51,1,'科技',35),(52,51,'科技',35),(53,51,'工程',35),(54,51,'建筑',35),(55,51,'医学',35),(56,51,'科学与自然',35),(57,51,'计算机与互联网',35),(58,51,'体育/运动',35),(59,1,'教育',35),(60,59,'教材教辅',35),(61,59,'教育与考试',35),(62,59,'外语学习',35),(64,59,'语言文字',35),(65,1,'港台图书',35),(66,65,'艺术/设计/收藏',35),(67,65,'经济管理',35),(68,65,'文化/学术',35),(69,65,'少儿文学/国学',35),(70,1,'其它',35),(71,70,'工具书',35),(72,70,'影印版',35),(73,70,'套装书',35),(74,0,'家用电器',35),(75,74,'大家电',35),(76,75,'平板电视',37),(77,75,'空调',35),(78,75,'冰箱',35),(79,75,'洗衣机',35),(80,75,'家庭影院',35),(81,75,'DVD播放机',35),(82,75,'迷你音响',35),(83,75,'烟机/灶具',35),(84,75,'热水器',35),(85,75,'消毒柜/洗碗机',35),(86,75,'酒柜/冰吧/冷柜',35),(87,75,'家电配件',35),(88,75,'家电下乡',35),(89,74,'生活电器',35),(90,89,'电风扇',35),(91,89,'冷风扇',35),(92,89,'净化器',35),(93,89,'饮水机',35),(94,89,'净水设备',35),(95,89,'挂烫机/熨斗',35),(96,89,'吸尘器',35),(97,89,'电话机',35),(98,89,'插座',35),(99,89,'收录/音机',35),(100,89,'清洁机',35),(101,89,'加湿器',35),(102,89,'除湿机',35),(103,89,'取暖电器',35),(104,89,'其它生活电器',35),(105,89,'扫地机器人',35),(106,89,'干衣机',35),(107,89,'生活电器配件',35),(108,74,'厨房电器',35),(109,108,'料理/榨汁机',35),(110,108,'豆浆机',35),(111,108,'电饭煲',35),(112,108,'电压力锅',35),(113,108,'面包机',35),(114,108,'咖啡机',35),(115,108,'微波炉',35),(116,108,'电烤箱',35),(117,108,'电磁炉',35),(118,108,'电饼铛/烧烤盘',35),(119,108,'煮蛋器',35),(120,108,'酸奶机',35),(121,108,'电炖锅',35),(122,108,'电水壶/热水瓶',35),(123,108,'多用途锅',35),(124,108,'果蔬解毒机',35),(125,108,'其它厨房电器',35),(126,74,'个护健康',35),(127,126,'剃须刀',35),(128,126,'剃/脱毛器',35),(129,126,'口腔护理',35),(130,126,'电吹风',35),(131,126,'美容器',35),(132,126,'美发器',35),(133,126,'按摩椅',35),(134,126,'按摩器',35),(135,126,'足浴盆',35),(136,126,'血压计',35),(137,126,'健康秤/厨房秤',35),(138,126,'血糖仪',35),(139,126,'体温计',35),(140,126,'计步器/脂肪检测仪',35),(141,126,'其它健康电器',35),(142,74,'五金家装',35),(143,142,'电动工具',35),(144,142,'手动工具',35),(145,142,'仪器仪表',35),(146,142,'浴霸/排气扇',35),(147,142,'灯具',35),(148,142,'LED灯',35),(149,142,'洁身器',35),(150,142,'水槽',35),(151,142,'龙头',35),(152,142,'淋浴花洒',35),(153,142,'厨卫五金',35),(154,142,'家具五金',35),(155,142,'门铃',35),(156,142,'电气开关',35),(157,142,'插座',35),(158,142,'电工电料',35),(159,142,'监控安防',35),(160,142,'电线线缆',35),(161,0,'电脑、办公',35),(162,161,'电脑整机',35),(163,162,'笔记本',35),(164,162,'超极本',35),(165,162,'游戏本',35),(166,162,'平板电脑',35),(167,162,'平板电脑配件',35),(168,162,'台式机',35),(169,162,'服务器/工作站',35),(170,162,'笔记本配件',35),(171,161,'电脑配件',35),(172,171,'CPU',35),(173,171,'主板',35),(174,171,'显卡',35),(175,171,'硬盘',35),(176,171,'SSD固态硬盘',35),(177,171,'内存',35),(178,171,'机箱',35),(179,171,'电源',35),(180,171,'显示器',35),(181,171,'刻录机/光驱',35),(182,171,'散热器',35),(183,171,'声卡/扩展卡',35),(184,171,'装机配件',35),(185,171,'组装电脑',35),(186,161,'外设产品',35),(187,186,'移动硬盘',35),(188,186,'U盘',35),(189,186,'鼠标',35),(190,186,'键盘',35),(191,186,'鼠标垫',35),(192,186,'摄像头',35),(193,186,'手写板',35),(194,186,'外置盒',35),(195,186,'插座',35),(196,186,'线缆',35),(197,186,'UPS电源',35),(198,186,'电脑工具',35),(199,186,'游戏设备',35),(200,186,'电玩',35),(201,186,'电脑清洁',35),(202,161,'网络产品',35),(203,202,'路由器',35),(204,202,'网卡',35),(205,202,'交换机',35),(206,202,'网络存储',35),(207,202,'4G/3G上网',35),(208,202,'网络盒子',35),(209,202,'网络配件',35),(210,161,'办公设备',35),(211,210,'投影机',35),(212,210,'投影配件',35),(213,210,'多功能一体机',35),(214,210,'打印机',35),(215,210,'传真设备',35),(216,210,'验钞/点钞机',35),(217,210,'扫描设备',35),(218,210,'复合机',35),(219,210,'碎纸机',35),(220,210,'考勤机',35),(221,210,'墨粉',35),(222,210,'收款/POS机',35),(223,210,'会议音频视频',35),(224,210,'保险柜',35),(225,210,'装订/封装机',35),(226,210,'安防监控',35),(227,210,'办公家具',35),(228,210,'白板',35),(229,161,'文具/耗材',35),(230,229,'硒鼓/墨粉',35),(231,229,'墨盒',35),(232,229,'色带',35),(233,229,'纸类',35),(234,229,'办公文具',35),(235,229,'学生文具',35),(236,229,'文件管理',35),(237,229,'财会用品',35),(238,229,'本册/便签',35),(239,229,'计算器',35),(240,229,'激光笔',35),(241,229,'笔类',35),(242,229,'画具画材',35),(243,229,'刻录碟片/附件',35),(244,161,'服务产品',35),(245,244,'上门服务',35),(246,244,'远程服务',35),(247,244,'电脑软件',35),(248,244,'京东服务',35),(249,0,'个护化妆',35),(250,249,'面部护肤',35),(251,250,'清洁',35),(252,250,'护肤',35),(253,250,'面膜',35),(254,250,'剃须',35),(255,250,'套装',35),(256,249,'身体护肤',35),(257,256,'沐浴',35),(258,256,'润肤',35),(259,256,'颈部',35),(260,256,'手足',35),(261,256,'纤体塑形',35),(262,256,'美胸',35),(263,256,'套装',35),(264,249,'口腔护理',35),(265,264,'牙膏/牙粉',35),(266,264,'牙刷/牙线',35),(267,264,'漱口水',35),(268,264,'套装',35),(269,249,'女性护理',35),(270,269,'卫生巾',35),(271,269,'卫生护垫',35),(272,269,'私密护理',35),(273,269,'脱毛膏',35),(274,249,'洗发护发',35),(275,274,'洗发',35),(276,274,'护发',35),(277,274,'染发',35),(278,274,'造型',35),(279,274,'假发',35),(280,274,'套装',35),(281,249,'香水彩妆',35),(282,281,'香水',35),(283,281,'底妆',35),(284,281,'腮红',35),(285,281,'眼部',35),(286,281,'唇部',35),(287,281,'美甲',35),(288,281,'美容工具',35),(289,281,'套装',35),(290,0,'钟表',35),(291,290,'钟表',35),(292,291,'男表',35),(293,291,'女表',35),(294,291,'儿童手表',35),(295,291,'座钟挂钟',35),(296,0,'母婴',35),(297,296,'奶粉',35),(298,297,'婴幼奶粉',35),(299,297,'成人奶粉',35),(300,296,'营养辅食',35),(301,300,'益生菌/初乳',35),(302,300,'米粉/菜粉',35),(303,300,'果泥/果汁',35),(304,300,'DHA',35),(305,300,'宝宝零食',35),(306,300,'钙铁锌/维生素',35),(307,300,'清火/开胃',35),(308,300,'面条/粥',35),(309,296,'尿裤湿巾',35),(310,309,'婴儿尿裤',35),(311,309,'拉拉裤',35),(312,309,'湿巾',35),(313,309,'成人尿裤',35),(314,296,'喂养用品',35),(315,314,'奶瓶奶嘴',35),(316,314,'吸奶器',35),(317,314,'暖奶消毒',35),(318,314,'碗盘叉勺',35),(319,314,'水壶/水杯',35),(320,314,'牙胶安抚',35),(321,314,'辅食料理机',35),(322,296,'洗护用品',35),(323,322,'宝宝护肤',35),(324,322,'宝宝洗浴',35),(325,322,'奶瓶清洗',35),(326,322,'驱蚊防蚊',35),(327,322,'理发器',35),(328,322,'洗衣液/皂',35),(329,322,'日常护理',35),(330,322,'座便器',35),(331,296,'童车童床',35),(332,331,'婴儿推车',35),(333,331,'餐椅摇椅',35),(334,331,'婴儿床',35),(335,331,'学步车',35),(336,331,'三轮车',35),(337,331,'自行车',35),(338,331,'电动车',35),(339,331,'扭扭车',35),(340,331,'滑板车',35),(341,296,'寝居服饰',35),(342,341,'婴儿外出服',35),(343,341,'婴儿内衣',35),(344,341,'婴儿礼盒',35),(345,341,'婴儿鞋帽袜',35),(346,341,'安全防护',35),(347,341,'家居床品',35),(348,296,'妈妈专区',35),(349,348,'妈咪包/背婴带',35),(350,348,'产后塑身',35),(351,348,'文胸/内裤',35),(352,348,'防辐射服',35),(353,348,'孕妇装',35),(354,348,'孕期营养',35),(355,348,'孕妈美容',35),(356,348,'待产/新生',35),(357,348,'月子装',35),(358,296,'童装童鞋',35),(359,358,'套装',35),(360,358,'上衣',35),(361,358,'裤子',35),(362,358,'裙子',35),(363,358,'内衣/家居服',35),(364,358,'羽绒服/棉服',35),(365,358,'亲子装',35),(366,358,'儿童配饰',35),(367,358,'礼服/演出服',35),(368,358,'运动鞋',35),(369,358,'皮鞋/帆布鞋',35),(370,358,'靴子',35),(371,358,'凉鞋',35),(372,358,'功能鞋',35),(373,358,'户外/运动服',35),(374,296,'安全座椅',35),(375,374,'提篮式',35),(376,374,'安全座椅',35),(377,374,'增高垫',35),(378,0,'食品饮料、保健食品',35),(379,378,'进口食品',35),(380,379,'饼干蛋糕',35),(381,379,'糖果/巧克力',35),(382,379,'休闲零食',35),(383,379,'冲调饮品',35),(384,379,'粮油调味',35),(385,379,'牛奶',35),(386,378,'地方特产',35),(387,386,'其他特产',35),(388,386,'新疆',35),(389,386,'北京',35),(390,386,'山西',35),(391,386,'内蒙古',35),(392,386,'福建',35),(393,386,'湖南',35),(394,386,'四川',35),(395,386,'云南',35),(396,386,'东北',35),(397,378,'休闲食品',35),(398,397,'休闲零食',35),(399,397,'坚果炒货',35),(400,397,'肉干肉脯',35),(401,397,'蜜饯果干',35),(402,397,'糖果/巧克力',35),(403,397,'饼干蛋糕',35),(404,397,'无糖食品',35),(405,378,'粮油调味',35),(406,405,'米面杂粮',35),(407,405,'食用油',35),(408,405,'调味品',35),(409,405,'南北干货',35),(410,405,'方便食品',35),(411,405,'有机食品',35),(412,378,'饮料冲调',35),(413,412,'饮用水',35),(414,412,'饮料',35),(415,412,'牛奶乳品',35),(416,412,'咖啡/奶茶',35),(417,412,'冲饮谷物',35),(418,412,'蜂蜜/柚子茶',35),(419,412,'成人奶粉',35),(420,378,'食品礼券',35),(421,420,'月饼',35),(422,420,'大闸蟹',35),(423,420,'粽子',35),(424,420,'卡券',35),(425,378,'茗茶',35),(426,425,'铁观音',35),(427,425,'普洱',35),(428,425,'龙井',35),(429,425,'绿茶',35),(430,425,'红茶',35),(431,425,'乌龙茶',35),(432,425,'花草茶',35),(433,425,'花果茶',35),(434,425,'养生茶',35),(435,425,'黑茶',35),(436,425,'白茶',35),(437,425,'其它茶',35),(438,0,'汽车用品',35),(439,438,'维修保养',35),(440,439,'润滑油',35),(441,439,'添加剂',35),(442,439,'防冻液',35),(443,439,'滤清器',35),(444,439,'火花塞',35),(445,439,'雨刷',35),(446,439,'车灯',35),(447,439,'后视镜',35),(448,439,'轮胎',35),(449,439,'轮毂',35),(450,439,'刹车片/盘',35),(451,439,'喇叭/皮带',35),(452,439,'蓄电池',35),(453,439,'底盘装甲/护板',35),(454,439,'贴膜',35),(455,439,'汽修工具',35),(456,438,'车载电器',35),(457,456,'导航仪',35),(458,456,'安全预警仪',35),(459,456,'行车记录仪',35),(460,456,'倒车雷达',35),(461,456,'蓝牙设备',35),(462,456,'时尚影音',35),(463,456,'净化器',35),(464,456,'电源',35),(465,456,'冰箱',35),(466,456,'吸尘器',35),(467,438,'美容清洗',35),(468,467,'车蜡',35),(469,467,'补漆笔',35),(470,467,'玻璃水',35),(471,467,'清洁剂',35),(472,467,'洗车工具',35),(473,467,'洗车配件',35),(474,438,'汽车装饰',35),(475,474,'脚垫',35),(476,474,'座垫',35),(477,474,'座套',35),(478,474,'后备箱垫',35),(479,474,'头枕腰靠',35),(480,474,'香水',35),(481,474,'空气净化',35),(482,474,'车内饰品',35),(483,474,'功能小件',35),(484,474,'车身装饰件',35),(485,474,'车衣',35),(486,438,'安全自驾',35),(487,486,'安全座椅',35),(488,486,'胎压充气',35),(489,486,'防盗设备',35),(490,486,'应急救援',35),(491,486,'保温箱',35),(492,486,'储物箱',35),(493,486,'自驾野营',35),(494,486,'摩托车装备',35),(495,0,'玩具乐器',35),(496,495,'适用年龄',35),(497,496,'0-6个月',35),(498,496,'6-12个月',35),(499,496,'1-3岁',35),(500,496,'3-6岁',35),(501,496,'6-14岁',35),(502,496,'14岁以上',35),(503,495,'遥控/电动',35),(504,503,'遥控车',35),(505,503,'遥控飞机',35),(506,503,'遥控船',35),(507,503,'机器人/电动',35),(508,503,'轨道/助力',35),(509,495,'毛绒布艺',35),(510,509,'毛绒/布艺',35),(511,509,'靠垫/抱枕',35),(512,495,'娃娃玩具',35),(513,512,'芭比娃娃',35),(514,512,'卡通娃娃',35),(515,512,'智能娃娃',35),(516,495,'模型玩具',35),(517,516,'仿真模型',35),(518,516,'拼插模型',35),(519,516,'收藏爱好',35),(520,495,'健身玩具',35),(521,520,'炫舞毯',35),(522,520,'爬行垫/毯',35),(523,520,'户外玩具',35),(524,520,'戏水玩具',35),(525,495,'动漫玩具',35),(526,525,'电影周边',35),(527,525,'卡通周边',35),(528,525,'网游周边',35),(529,495,'益智玩具',35),(530,529,'摇铃/床铃',35),(531,529,'健身架',35),(532,529,'早教启智',35),(533,529,'拖拉玩具',35),(534,495,'积木拼插',35),(535,534,'积木',35),(536,534,'拼图',35),(537,534,'磁力棒',35),(538,534,'立体拼插',35),(539,495,'DIY玩具',35),(540,539,'手工彩泥',35),(541,539,'绘画工具',35),(542,539,'情景玩具',35),(543,495,'创意减压',35),(544,543,'减压玩具',35),(545,543,'创意玩具',35),(546,495,'乐器相关',35),(547,546,'钢琴',35),(548,546,'电子琴',35),(549,546,'手风琴',35),(550,546,'吉他/贝斯',35),(551,546,'民族管弦乐器',35),(552,546,'西洋管弦乐',35),(553,546,'口琴/口风琴/竖笛',35),(554,546,'西洋打击乐器',35),(555,546,'各式乐器配件',35),(556,546,'电脑音乐',35),(557,546,'工艺礼品乐器',35),(558,0,'手机',35),(559,558,'手机通讯',35),(560,559,'手机',35),(561,559,'对讲机',35),(562,558,'运营商',35),(563,562,'购机送费',35),(564,562,'“0”元购机',35),(565,562,'选号中心',35),(566,562,'选号入网',35),(567,558,'手机配件',35),(568,567,'手机电池',35),(569,567,'蓝牙耳机',35),(570,567,'充电器/数据线',35),(571,567,'手机耳机',35),(572,567,'手机贴膜',35),(573,567,'手机存储卡',35),(574,567,'手机保护套',35),(575,567,'车载配件',35),(576,567,'iPhone 配件',35),(577,567,'创意配件',35),(578,567,'便携/无线音响',35),(579,567,'手机饰品',35),(580,0,'数码',35),(581,580,'摄影摄像',35),(582,581,'数码相机',35),(583,581,'单电/微单相机',35),(584,581,'单反相机',35),(585,581,'摄像机',35),(586,581,'拍立得',35),(587,581,'运动相机',35),(588,581,'镜头',35),(589,581,'户外器材',35),(590,581,'影棚器材',35),(591,580,'数码配件',35),(592,591,'存储卡',35),(593,591,'读卡器',35),(594,591,'滤镜',35),(595,591,'闪光灯/手柄',35),(596,591,'相机包',35),(597,591,'三脚架/云台',35),(598,591,'相机清洁',35),(599,591,'相机贴膜',35),(600,591,'机身附件',35),(601,591,'镜头附件',35),(602,591,'电池/充电器',35),(603,591,'移动电源',35),(604,580,'智能设备',35),(605,604,'智能手环',35),(606,604,'智能手表',35),(607,604,'智能眼镜',35),(608,604,'运动跟踪器',35),(609,604,'健康监测',35),(610,604,'智能配饰',35),(611,604,'智能家居',35),(612,604,'体感车',35),(613,604,'其他配件',35),(614,580,'时尚影音',35),(615,614,'MP3/MP4',35),(616,614,'智能设备',35),(617,614,'耳机/耳麦',35),(618,614,'音箱',35),(619,614,'高清播放器',35),(620,614,'MP3/MP4配件',35),(621,614,'麦克风',35),(622,614,'专业音频',35),(623,614,'数码相框',35),(624,614,'苹果配件',35),(625,580,'电子教育',35),(626,625,'电子词典',35),(627,625,'电纸书',35),(628,625,'录音笔',35),(629,625,'复读机',35),(630,625,'点读机/笔',35),(631,625,'学生平板',35),(632,625,'早教机',35),(633,0,'家居家装',35),(634,633,'家纺',35),(635,634,'床品套件',35),(636,634,'被子',35),(637,634,'枕芯',35),(638,634,'床单被罩',35),(639,634,'毯子',35),(640,634,'床垫/床褥',35),(641,634,'蚊帐',35),(642,634,'抱枕靠垫',35),(643,634,'毛巾浴巾',35),(644,634,'电热毯',35),(645,634,'窗帘/窗纱',35),(646,634,'布艺软饰',35),(647,634,'凉席',35),(648,633,'灯具',35),(649,648,'台灯',35),(650,648,'节能灯',35),(651,648,'装饰灯',35),(652,648,'落地灯',35),(653,648,'应急灯/手电',35),(654,648,'LED灯',35),(655,648,'吸顶灯',35),(656,648,'五金电器',35),(657,648,'筒灯射灯',35),(658,648,'吊灯',35),(659,648,'氛围照明',35),(660,633,'生活日用',35),(661,660,'收纳用品',35),(662,660,'雨伞雨具',35),(663,660,'浴室用品',35),(664,660,'缝纫/针织用品',35),(665,660,'洗晒/熨烫',35),(666,660,'净化除味',35),(667,633,'家装软饰',35),(668,667,'桌布/罩件',35),(669,667,'地毯地垫',35),(670,667,'沙发垫套/椅垫',35),(671,667,'相框/照片墙',35),(672,667,'装饰字画',35),(673,667,'节庆饰品',35),(674,667,'手工/十字绣',35),(675,667,'装饰摆件',35),(676,667,'保暖防护',35),(677,667,'帘艺隔断',35),(678,667,'墙贴/装饰贴',35),(679,667,'钟饰',35),(680,667,'花瓶花艺',35),(681,667,'香薰蜡烛',35),(682,667,'创意家居',35),(683,633,'清洁用品',35),(684,683,'纸品湿巾',35),(685,683,'衣物清洁',35),(686,683,'清洁工具',35),(687,683,'驱虫用品',35),(688,683,'家庭清洁',35),(689,683,'皮具护理',35),(690,683,'一次性用品',35),(691,633,'宠物生活',35),(692,691,'宠物主粮',35),(693,691,'宠物零食',35),(694,691,'医疗保健',35),(695,691,'家居日用',35),(696,691,'宠物玩具',35),(697,691,'出行装备',35),(698,691,'洗护美容',35),(699,0,'厨具',35),(700,699,'烹饪锅具',35),(701,700,'炒锅',35),(702,700,'煎锅',35),(703,700,'压力锅',35),(704,700,'蒸锅',35),(705,700,'汤锅',35),(706,700,'奶锅',35),(707,700,'锅具套装',35),(708,700,'煲类',35),(709,700,'水壶',35),(710,700,'火锅',35),(711,699,'刀剪菜板',35),(712,711,'菜刀',35),(713,711,'剪刀',35),(714,711,'刀具套装',35),(715,711,'砧板',35),(716,711,'瓜果刀/刨',35),(717,711,'多功能刀',35),(718,699,'厨房配件',35),(719,718,'保鲜盒',35),(720,718,'烘焙/烧烤',35),(721,718,'饭盒/提锅',35),(722,718,'储物/置物架',35),(723,718,'厨房DIY/小工具',35),(724,699,'水具酒具',35),(725,724,'塑料杯',35),(726,724,'运动水壶',35),(727,724,'玻璃杯',35),(728,724,'陶瓷/马克杯',35),(729,724,'保温杯',35),(730,724,'保温壶',35),(731,724,'酒杯/酒具',35),(732,724,'杯具套装',35),(733,699,'餐具',35),(734,733,'餐具套装',35),(735,733,'碗/碟/盘',35),(736,733,'筷勺/刀叉',35),(737,733,'一次性用品',35),(738,733,'果盘/果篮',35),(739,699,'茶具/咖啡具',35),(740,739,'整套茶具',35),(741,739,'茶杯',35),(742,739,'茶壶',35),(743,739,'茶盘茶托',35),(744,739,'茶叶罐',35),(745,739,'茶具配件',35),(746,739,'茶宠摆件',35),(747,739,'咖啡具',35),(748,739,'其他',35),(749,0,'服饰内衣',35),(750,749,'女装',35),(751,750,'T恤',35),(752,750,'衬衫',35),(753,750,'针织衫',35),(754,750,'雪纺衫',35),(755,750,'卫衣',35),(756,750,'马甲',35),(757,750,'连衣裙',35),(758,750,'半身裙',35),(759,750,'牛仔裤',35),(760,750,'休闲裤',35),(761,750,'打底裤',35),(762,750,'正装裤',35),(763,750,'小西装',35),(764,750,'短外套',35),(765,750,'风衣',35),(766,750,'毛呢大衣',35),(767,750,'真皮皮衣',35),(768,750,'棉服',35),(769,750,'羽绒服',35),(770,750,'大码女装',35),(771,750,'中老年女装',35),(772,750,'婚纱',35),(773,750,'打底衫',35),(774,750,'旗袍/唐装',35),(775,750,'加绒裤',35),(776,750,'吊带/背心',35),(777,750,'羊绒衫',35),(778,750,'短裤',35),(779,750,'皮草',35),(780,750,'礼服',35),(781,750,'仿皮皮衣',35),(782,750,'羊毛衫',35),(783,750,'设计师/潮牌',35),(784,749,'男装',35),(785,784,'衬衫',35),(786,784,'T恤',35),(787,784,'POLO衫',35),(788,784,'针织衫',35),(789,784,'羊绒衫',35),(790,784,'卫衣',35),(791,784,'马甲/背心',35),(792,784,'夹克',35),(793,784,'风衣',35),(794,784,'毛呢大衣',35),(795,784,'仿皮皮衣',35),(796,784,'西服',35),(797,784,'棉服',35),(798,784,'羽绒服',35),(799,784,'牛仔裤',35),(800,784,'休闲裤',35),(801,784,'西裤',35),(802,784,'西服套装',35),(803,784,'大码男装',35),(804,784,'中老年男装',35),(805,784,'唐装/中山装',35),(806,784,'工装',35),(807,784,'真皮皮衣',35),(808,784,'加绒裤',35),(809,784,'卫裤/运动裤',35),(810,784,'短裤',35),(811,784,'设计师/潮牌',35),(812,784,'羊毛衫',35),(813,749,'内衣',35),(814,813,'文胸',35),(815,813,'女式内裤',35),(816,813,'男式内裤',35),(817,813,'睡衣/家居服',35),(818,813,'塑身美体',35),(819,813,'泳衣',35),(820,813,'吊带/背心',35),(821,813,'抹胸',35),(822,813,'连裤袜/丝袜',35),(823,813,'美腿袜',35),(824,813,'商务男袜',35),(825,813,'保暖内衣',35),(826,813,'情侣睡衣',35),(827,813,'文胸套装',35),(828,813,'少女文胸',35),(829,813,'休闲棉袜',35),(830,813,'大码内衣',35),(831,813,'内衣配件',35),(832,813,'打底裤袜',35),(833,813,'打底衫',35),(834,813,'秋衣秋裤',35),(835,813,'情趣内衣',35),(836,749,'服饰配件',35),(837,836,'太阳镜',35),(838,836,'光学镜架/镜片',35),(839,836,'围巾/手套/帽子套装',35),(840,836,'袖扣',35),(841,836,'棒球帽',35),(842,836,'毛线帽',35),(843,836,'遮阳帽',35),(844,836,'老花镜',35),(845,836,'装饰眼镜',35),(846,836,'防辐射眼镜',35),(847,836,'游泳镜',35),(848,836,'女士丝巾/围巾/披肩',35),(849,836,'男士丝巾/围巾',35),(850,836,'鸭舌帽',35),(851,836,'贝雷帽',35),(852,836,'礼帽',35),(853,836,'真皮手套',35),(854,836,'毛线手套',35),(855,836,'防晒手套',35),(856,836,'男士腰带/礼盒',35),(857,836,'女士腰带/礼盒',35),(858,836,'钥匙扣',35),(859,836,'遮阳伞/雨伞',35),(860,836,'口罩',35),(861,836,'耳罩/耳包',35),(862,836,'假领',35),(863,836,'毛线/布面料',35),(864,836,'领带/领结/领带夹',35),(865,0,'鞋靴',35),(866,865,'流行男鞋',35),(867,866,'商务休闲鞋',35),(868,866,'正装鞋',35),(869,866,'休闲鞋',35),(870,866,'凉鞋/沙滩鞋',35),(871,866,'男靴',35),(872,866,'功能鞋',35),(873,866,'拖鞋/人字拖',35),(874,866,'雨鞋/雨靴',35),(875,866,'传统布鞋',35),(876,866,'鞋配件',35),(877,866,'帆布鞋',35),(878,866,'增高鞋',35),(879,866,'工装鞋',35),(880,866,'定制鞋',35),(881,865,'时尚女鞋',35),(882,881,'高跟鞋',35),(883,881,'单鞋',35),(884,881,'休闲鞋',35),(885,881,'凉鞋',35),(886,881,'女靴',35),(887,881,'雪地靴',35),(888,881,'拖鞋/人字拖',35),(889,881,'踝靴',35),(890,881,'筒靴',35),(891,881,'帆布鞋',35),(892,881,'雨鞋/雨靴',35),(893,881,'妈妈鞋',35),(894,881,'鞋配件',35),(895,881,'特色鞋',35),(896,881,'鱼嘴鞋',35),(897,881,'布鞋/绣花鞋',35),(898,881,'马丁靴',35),(899,881,'坡跟鞋',35),(900,881,'松糕鞋',35),(901,881,'内增高',35),(902,881,'防水台',35),(903,0,'礼品箱包',35),(904,903,'潮流女包',35),(905,904,'钱包',35),(906,904,'手拿包/晚宴包',35),(907,904,'单肩包',35),(908,904,'双肩包',35),(909,904,'手提包',35),(910,904,'斜挎包',35),(911,904,'钥匙包',35),(912,904,'卡包/零钱包',35),(913,903,'精品男包',35),(914,913,'钱包/卡包',35),(915,913,'男士手包',35),(916,913,'商务公文包',35),(917,913,'双肩包',35),(918,913,'单肩/斜挎包',35),(919,913,'钥匙包',35),(920,903,'功能箱包',35),(921,920,'电脑包',35),(922,920,'拉杆箱/拉杆包',35),(923,920,'旅行包',35),(924,920,'旅行配件',35),(925,920,'休闲运动包',35),(926,920,'登山包',35),(927,920,'妈咪包',35),(928,920,'书包',35),(929,920,'相机包',35),(930,920,'腰包/胸包',35),(931,903,'礼品',35),(932,931,'火机烟具',35),(933,931,'礼品文具',35),(934,931,'军刀军具',35),(935,931,'收藏品',35),(936,931,'工艺礼品',35),(937,931,'创意礼品',35),(938,931,'礼盒礼券',35),(939,931,'鲜花绿植',35),(940,931,'婚庆用品',35),(941,931,'京东卡',35),(942,931,'美妆礼品',35),(943,931,'地方礼品',35),(944,931,'古董把玩',35),(945,903,'奢侈品',35),(946,945,'箱包',35),(947,945,'钱包',35),(948,945,'服饰',35),(949,945,'腰带',35),(950,945,'太阳镜/眼镜框',35),(951,945,'配件',35),(952,945,'鞋靴',35),(953,945,'饰品',35),(954,945,'名品腕表',35),(955,945,'高档化妆品',35),(956,903,'婚庆',35),(957,956,'婚嫁首饰',35),(958,956,'婚纱摄影',35),(959,956,'婚纱礼服',35),(960,956,'婚庆服务',35),(961,956,'婚庆礼品/用品',35),(962,956,'婚宴',35),(963,0,'珠宝',35),(964,963,'时尚饰品',35),(965,964,'项链',35),(966,964,'手链/脚链',35),(967,964,'戒指',35),(968,964,'耳饰',35),(969,964,'头饰',35),(970,964,'胸针',35),(971,964,'婚庆饰品',35),(972,964,'饰品配件',35),(973,963,'纯金K金饰品',35),(974,973,'吊坠/项链',35),(975,973,'手镯/手链/脚链',35),(976,973,'戒指',35),(977,973,'耳饰',35),(978,963,'金银投资',35),(979,978,'工艺金',35),(980,978,'工艺银',35),(981,963,'银饰',35),(982,981,'吊坠/项链',35),(983,981,'手镯/手链/脚链',35),(984,981,'戒指/耳饰',35),(985,981,'宝宝银饰',35),(986,981,'千足银手镯',35),(987,963,'钻石',35),(988,987,'裸钻',35),(989,987,'戒指',35),(990,987,'项链/吊坠',35),(991,987,'耳饰',35),(992,987,'手镯/手链',35),(993,963,'翡翠玉石',35),(994,993,'项链/吊坠',35),(995,993,'手镯/手串',35),(996,993,'戒指',35),(997,993,'耳饰',35),(998,993,'挂件/摆件/把件',35),(999,993,'高值收藏',35),(1000,963,'水晶玛瑙',35),(1001,1000,'项链/吊坠',35),(1002,1000,'耳饰',35),(1003,1000,'手镯/手链/脚链',35),(1004,1000,'戒指',35),(1005,1000,'头饰/胸针',35),(1006,1000,'摆件/挂件',35),(1007,963,'彩宝',35),(1008,1007,'项链/吊坠',35),(1009,1007,'耳饰',35),(1010,1007,'手镯/手链',35),(1011,1007,'戒指',35),(1012,963,'铂金',35),(1013,1012,'项链/吊坠',35),(1014,1012,'手镯/手链/脚链',35),(1015,1012,'戒指',35),(1016,1012,'耳饰',35),(1017,963,'天然木饰',35),(1018,1017,'小叶紫檀',35),(1019,1017,'黄花梨',35),(1020,1017,'沉香',35),(1021,1017,'金丝楠',35),(1022,1017,'菩提',35),(1023,1017,'其他',35),(1024,963,'珍珠',35),(1025,1024,'项链',35),(1026,1024,'吊坠',35),(1027,1024,'耳饰',35),(1028,1024,'手链',35),(1029,1024,'戒指',35),(1030,1024,'胸针',35),(1031,0,'运动健康',35),(1032,1031,'运动鞋包',35),(1033,1032,'休闲鞋',35),(1034,1032,'板鞋',35),(1035,1032,'帆布鞋',35),(1036,1032,'专项运动鞋',35),(1037,1032,'跑步鞋',35),(1038,1032,'篮球鞋',35),(1039,1032,'足球鞋',35),(1040,1032,'训练鞋',35),(1041,1032,'乒羽网鞋',35),(1042,1032,'拖鞋',35),(1043,1032,'运动包',35),(1044,1031,'运动服饰',35),(1045,1044,'运动配饰',35),(1046,1044,'羽绒服',35),(1047,1044,'毛衫/线衫',35),(1048,1044,'乒羽网服',35),(1049,1044,'训练服',35),(1050,1044,'运动背心',35),(1051,1044,'卫衣/套头衫',35),(1052,1044,'夹克/风衣',35),(1053,1044,'T恤',35),(1054,1044,'棉服',35),(1055,1044,'运动裤',35),(1056,1044,'套装',35),(1057,1031,'骑行运动',35),(1058,1057,'折叠车',35),(1059,1057,'山地车/公路车',35),(1060,1057,'电动车',35),(1061,1057,'其他整车',35),(1062,1057,'骑行服',35),(1063,1057,'骑行装备',35),(1064,1031,'垂钓用品',35),(1065,1064,'鱼竿鱼线',35),(1066,1064,'浮漂鱼饵',35),(1067,1064,'钓鱼桌椅',35),(1068,1064,'钓鱼配件',35),(1069,1064,'钓箱鱼包',35),(1070,1064,'其它',35),(1071,1031,'游泳用品',35),(1072,1071,'泳镜',35),(1073,1071,'泳帽',35),(1074,1071,'游泳包防水包',35),(1075,1071,'女士泳衣',35),(1076,1071,'男士泳衣',35),(1077,1071,'比基尼',35),(1078,1071,'其它',35),(1079,1031,'户外鞋服',35),(1080,1079,'冲锋衣裤',35),(1081,1079,'速干衣裤',35),(1082,1079,'滑雪服',35),(1083,1079,'羽绒服/棉服',35),(1084,1079,'休闲衣裤',35),(1085,1079,'抓绒衣裤',35),(1086,1079,'软壳衣裤',35),(1087,1079,'T恤',35),(1088,1079,'户外风衣',35),(1089,1079,'功能内衣',35),(1090,1079,'军迷服饰',35),(1091,1079,'登山鞋',35),(1092,1079,'雪地靴',35),(1093,1079,'徒步鞋',35),(1094,1079,'越野跑鞋',35),(1095,1079,'休闲鞋',35),(1096,1079,'工装鞋',35),(1097,1079,'溯溪鞋',35),(1098,1079,'沙滩/凉拖',35),(1099,1079,'户外袜',35),(1100,1031,'户外装备',35),(1101,1100,'帐篷/垫子',35),(1102,1100,'睡袋/吊床',35),(1103,1100,'登山攀岩',35),(1104,1100,'背包',35),(1105,1100,'户外配饰',35),(1106,1100,'户外照明',35),(1107,1100,'户外仪表',35),(1108,1100,'户外工具',35),(1109,1100,'望远镜',35),(1110,1100,'旅游用品',35),(1111,1100,'便携桌椅床',35),(1112,1100,'野餐烧烤',35),(1113,1100,'军迷用品',35),(1114,1100,'救援装备',35),(1115,1100,'滑雪装备',35),(1116,1100,'极限户外',35),(1117,1100,'冲浪潜水',35),(1118,1031,'健身训练',35),(1119,1118,'综合训练器',35),(1120,1118,'其他大型器械',35),(1121,1118,'哑铃',35),(1122,1118,'仰卧板/收腹机',35),(1123,1118,'其他中小型器材',35),(1124,1118,'瑜伽舞蹈',35),(1125,1118,'武术搏击',35),(1126,1118,'健身车/动感单车',35),(1127,1118,'跑步机',35),(1128,1118,'运动护具',35),(1129,1031,'纤体瑜伽',35),(1130,1129,'瑜伽垫',35),(1131,1129,'瑜伽服',35),(1132,1129,'瑜伽配件',35),(1133,1129,'瑜伽套装',35),(1134,1129,'舞蹈鞋服',35),(1135,1031,'体育用品',35),(1136,1135,'羽毛球',35),(1137,1135,'乒乓球',35),(1138,1135,'篮球',35),(1139,1135,'足球',35),(1140,1135,'网球',35),(1141,1135,'排球',35),(1142,1135,'高尔夫',35),(1143,1135,'台球',35),(1144,1135,'棋牌麻将',35),(1145,1135,'轮滑滑板',35),(1146,1135,'其他',35),(1147,0,'彩票、旅行、充值、票务',35),(1148,1147,'彩票',35),(1149,1148,'双色球',35),(1150,1148,'大乐透',35),(1151,1148,'福彩3D',35),(1152,1148,'排列三',35),(1153,1148,'排列五',35),(1154,1148,'七星彩',35),(1155,1148,'七乐彩',35),(1156,1148,'竞彩足球',35),(1157,1148,'竞彩篮球',35),(1158,1148,'新时时彩',35),(1159,1147,'机票',35),(1160,1159,'国内机票',35),(1161,1147,'酒店',35),(1162,1161,'国内酒店',35),(1163,1161,'酒店团购',35),(1164,1147,'旅行',35),(1165,1164,'度假',35),(1166,1164,'景点',35),(1167,1164,'租车',35),(1168,1164,'火车票',35),(1169,1164,'旅游团购',35),(1170,1147,'充值',35),(1171,1170,'手机充值',35),(1172,1147,'游戏',35),(1173,1172,'游戏点卡',35),(1174,1172,'QQ充值',35),(1175,1147,'票务',35),(1176,1175,'电影票',35),(1177,1175,'演唱会',35),(1178,1175,'话剧歌剧',35),(1179,1175,'音乐会',35),(1180,1175,'体育赛事',35),(1181,1175,'舞蹈芭蕾',35),(1182,1175,'戏曲综艺',35),(1186,0,'小白大数据',35),(1187,1186,'大数据学科',35),(1188,1187,'hadoop',35),(1189,1187,'storm',35),(1190,1187,'kafka',35),(1191,18,'分类测试_毛祥溢',35),(1192,74,'小家电',35),(1193,11,'英文小说',35),(1194,718,'火锅涮锅',35),(1195,1192,'手电筒',35),(1196,1192,'照妖镜',35),(1197,274,'AA',35),(1198,987,'蓝宝石',35),(1199,2,'电子小说',35),(1200,162,'上网本',35),(1201,341,'婴儿礼服',35),(1202,2,'电子漫画书',35),(1203,186,'不移动软盘',35),(1204,562,'购机送流量',35);

INSERT INTO tb_goods_desc (goods_id, specification_items, custom_attribute_items, item_images, package_list, sale_service) VALUES (149187842867912,'[{\"attributeName\":\"网络\",\"attributeValue\":[\"移动3G\",\"移动4G\"]},{\"attributeName\":\"屏幕尺寸\",\"attributeValue\":[\"6寸\",\"5寸\"]}]','[{\"text\":\"内存大小\",\"value\":\"10M\"},{\"text\":\"颜色\",\"value\":\"花\"}]','[{\"color\":\"白色\",\"url\":\"http://192.168.192.132/group1/M00/00/04/wKiOklrSmiGAXGqvAAE05ISJidY899.jpg\"},{\"color\":\"白色\",\"url\":\"http://192.168.192.132/group1/M00/00/04/wKiOklrSmi6AAA04AAE05ISJidY233.jpg\"}]','USB线，充电器，说明书','1月包退，1年包换，3年保修，终身免费清洗'),(149187842867913,NULL,NULL,NULL,'没有包装','没有售后'),(149187842867914,NULL,NULL,NULL,'没有','真没有'),(149187842867916,'[{\"attributeName\":\"网络制式\",\"attributeValue\":[\"移动3G\",\"移动4G\"]},{\"attributeName\":\"屏幕尺寸\",\"attributeValue\":[\"6寸\",\"5寸\"]}]','[{\"text\":\"内存大小\",\"value\":\"10M\"},{\"text\":\"颜色\",\"value\":\"花\"}]','[]','没有','真没有'),(149187842867917,'[{\"attributeName\":\"网络制式\",\"attributeValue\":[\"移动3G\",\"移动4G\"]},{\"attributeName\":\"屏幕尺寸\",\"attributeValue\":[\"6寸\",\"5.5寸\"]}]','[{\"text\":\"内存大小\"},{\"text\":\"颜色\"}]','[]',NULL,NULL),(149187842867918,'[{\"attributeName\":\"网络制式\",\"attributeValue\":[\"移动3G\",\"移动4G\"]},{\"attributeName\":\"屏幕尺寸\",\"attributeValue\":[\"5.5寸\",\"5寸\"]}]','[{\"text\":\"内存大小\"},{\"text\":\"颜色\"}]','[]','11','11'),(149187842867919,NULL,NULL,'[{\"color\":\"白色\",\"url\":\"http://192.168.25.133/group1/M00/00/00/wKgZhVmNXEWAWuHOAAjlKdWCzvg949.jpg\"},{\"color\":\"黑色\",\"url\":\"http://192.168.25.133/group1/M00/00/00/wKgZhVmNXEuAB_ujAAETwD7A1Is158.jpg\"},{\"color\":\"蓝色\",\"url\":\"http://192.168.25.133/group1/M00/00/00/wKgZhVmNXFWANtjTAAFa4hmtWek619.jpg\"}]','100','100'),(149187842867920,NULL,NULL,'[]','纸箱','一年'),(149187842867921,NULL,'[{\"text\":\"内存大小\",\"value\":\"40M\"},{\"text\":\"颜色\",\"value\":\"透明\"}]','[]','没有','没有'),(149187842867922,'[{\"attributeName\":\"网络制式\",\"attributeValue\":[\"移动4G\"]},{\"attributeName\":\"屏幕尺寸\",\"attributeValue\":[\"5.5寸\",\"4.5寸\"]}]','[{\"text\":\"内存大小\"},{\"text\":\"颜色\"}]','[]','四个包','没有'),(149187842867923,'[{\"attributeName\":\"网络制式\",\"attributeValue\":[\"移动3G\",\"移动4G\"]},{\"attributeName\":\"屏幕尺寸\",\"attributeValue\":[\"6寸\",\"5.5寸\"]}]','[{\"text\":\"内存大小\"},{\"text\":\"颜色\"}]','[]','1','1'),(149187842867924,'[{\"attributeName\":\"网络制式\",\"attributeValue\":[\"移动3G\",\"移动4G\"]},{\"attributeName\":\"屏幕尺寸\",\"attributeValue\":[\"6寸\",\"5.5寸\"]}]','[{\"text\":\"内存大小\"},{\"text\":\"颜色\"}]','[]','10','10'),(149187842867925,'[{\"attributeName\":\"网络制式\",\"attributeValue\":[\"移动3G\",\"移动4G\"]},{\"attributeName\":\"屏幕尺寸\",\"attributeValue\":[\"6寸\",\"5.5寸\"]}]','[{\"text\":\"内存大小\"},{\"text\":\"颜色\"}]','[]','1','1'),(149187842867926,'[{\"attributeName\":\"网络制式\",\"attributeValue\":[\"移动3G\",\"移动4G\"]},{\"attributeName\":\"屏幕尺寸\",\"attributeValue\":[\"5.5寸\",\"5寸\"]}]','[{\"text\":\"内存大小\"},{\"text\":\"颜色\"}]','[]','11','11'),(149187842867927,'[]','[{\"text\":\"内存大小\",\"value\":\"10M\"},{\"text\":\"颜色\"}]','[{\"color\":\"白色\",\"url\":\"http://192.168.25.133/group1/M00/00/00/wKgZhVmOWsOAPwNYAAjlKdWCzvg742.jpg\"},{\"color\":\"黑色\",\"url\":\"http://192.168.25.133/group1/M00/00/00/wKgZhVmOWs2ABppQAAETwD7A1Is142.jpg\"}]','无','无'),(149187842867928,'[]','[{\"text\":\"内存大小\",\"value\":\"10M\"},{\"text\":\"颜色\",\"value\":\"红色\"}]','[{\"color\":\"黄色\",\"url\":\"http://192.168.25.133/group1/M00/00/00/wKgZhVmOXbeAC_kjAAjlKdWCzvg391.jpg\"},{\"color\":\"黑色\",\"url\":\"http://192.168.25.133/group1/M00/00/00/wKgZhVmOXcKATOFiAAETwD7A1Is494.jpg\"}]','222','333'),(149187842867929,'[]','[{\"text\":\"内存大小\",\"value\":\"19M\"},{\"text\":\"颜色\",\"value\":\"黑色\"}]','[{\"color\":\"粉色\",\"url\":\"http://192.168.25.133/group1/M00/00/00/wKgZhVmOXq2AFIs5AAgawLS1G5Y004.jpg\"},{\"color\":\"黑色\",\"url\":\"http://192.168.25.133/group1/M00/00/00/wKgZhVmOXrWAcIsOAAETwD7A1Is874.jpg\"}]','无','无'),(149187842867930,'[{\"attributeName\":\"网络制式\",\"attributeValue\":[\"移动3G\",\"移动4G\",\"联通3G\"]},{\"attributeName\":\"屏幕尺寸\",\"attributeValue\":[\"5.5寸\",\"6寸\"]}]','[{\"text\":\"内存大小\",\"value\":\"200M\"},{\"text\":\"颜色\",\"value\":\"白\"}]','[{\"color\":\"白色\",\"url\":\"http://192.168.25.133/group1/M00/00/00/wKgZhVmOZxyAfH5xAAFa4hmtWek092.jpg\"}]','无包装','一年'),(149187842867931,'[]','[{\"text\":\"内存大小\",\"value\":\"10M\"},{\"text\":\"颜色\",\"value\":\"红\"}]','[]','10','10'),(149187842867932,'[{\"attributeName\":\"网络制式\",\"attributeValue\":[\"移动3G\",\"移动4G\"]},{\"attributeName\":\"屏幕尺寸\",\"attributeValue\":[\"6寸\",\"5.5寸\"]}]','[{\"text\":\"内存大小\",\"value\":\"101M\"},{\"text\":\"颜色\",\"value\":\"红色\"}]','[]','11','1'),(149187842867933,'[]','[{\"text\":\"内存大小\",\"value\":\"10G\"},{\"text\":\"颜色\",\"value\":\"红色\"}]','[{\"color\":\"白色\",\"url\":\"http://192.168.25.133/group1/M00/00/00/wKgZhVnGZfWAaX2hAAjlKdWCzvg173.jpg\"}]','22','33'),(149187842867934,'[{\"attributeName\":\"网络\",\"attributeValue\":[\"移动3G\",\"移动4G\"]},{\"attributeName\":\"机身内存\",\"attributeValue\":[\"16G\",\"32G\"]}]','[{\"text\":\"内存大小\",\"value\":\"20G\"},{\"text\":\"颜色\",\"value\":\"灰色\"}]','[{\"color\":\"白色\",\"url\":\"http://192.168.25.133/group1/M00/00/00/wKgZhVnGbYuAO6AHAAjlKdWCzvg253.jpg\"},{\"color\":\"蓝色\",\"url\":\"http://192.168.25.133/group1/M00/00/00/wKgZhVnKX4yAbCC0AAFa4hmtWek406.jpg\"},{\"color\":\"黑色\",\"url\":\"http://192.168.25.133/group1/M00/00/00/wKgZhVnKX5WAOsqXAAETwD7A1Is409.jpg\"}]','塑料袋','无'),(149187842867935,NULL,NULL,NULL,'手机x1, 耳机x1','三年保修'),(149187842867936,'[{\"attributeValue\":[\"移动3G\",\"移动4G\",\"联通3G\"],\"attributeName\":\"网络\"},{\"attributeValue\":[\"16G\",\"32G\"],\"attributeName\":\"机身内存\"}]',NULL,'[{\"color\":\"黑色\",\"url\":\"http://192.168.192.132/group1/M00/00/03/wKiOi1qaubqADztSAASIdvRMxJI202.jpg\"},{\"color\":\"香槟色\",\"url\":\"http://192.168.192.132/group1/M00/00/03/wKiOi1qaucmAeD3xAAf4ro-dy9A782.jpg\"}]','手机x1, 数据线x1, 耳机x1','三年质保'),(149187842867937,'[]',NULL,'[{\"color\":\"白色\",\"url\":\"http://192.168.192.132/group1/M00/00/03/wKiOi1qavamAUWSYAAE05ISJidY551.jpg\"},{\"color\":\"黑色\",\"url\":\"http://192.168.192.132/group1/M00/00/03/wKiOi1qavb2APkn9AALaJOTK9qM176.jpg\"}]','手机x1','三年质保'),(149187842867938,'[{\"attributeName\":\"网络\",\"attributeValue\":[\"移动3G\",\"移动4G\"]},{\"attributeName\":\"机身内存\",\"attributeValue\":[\"32G\",\"64G\"]}]','[{\"text\":\"内存大小\",\"value\":\"4G\"},{\"text\":\"颜色\",\"value\":\"白色\"}]','[{\"color\":\"白色\",\"url\":\"http://192.168.192.132/group1/M00/00/03/wKiOi1qawACATK40AAE05ISJidY520.jpg\"},{\"color\":\"黑色\",\"url\":\"http://192.168.192.132/group1/M00/00/03/wKiOi1qawAqANCcGAALaJOTK9qM284.jpg\"}]','手机x1','三年质保'),(149187842867947,'[{\"attributeName\":\"网络\",\"attributeValue\":[\"移动3G\",\"移动4G\",\"联通3G\",\"联通4G\",\"电信3G\",\"电信4G\",\"移动2G\",\"联通2G\",\"电信2G\",\"双卡\"]},{\"attributeName\":\"机身内存\",\"attributeValue\":[\"16G\",\"64G\",\"128G\"]}]','[{\"text\":\"内存大小\",\"value\":\"64G\"},{\"text\":\"颜色\",\"value\":\"黑色\"}]','[{\"color\":\"金色\",\"url\":\"http://192.168.192.132/group1/M00/00/03/wKiOi1qvMAuAeKKdAABvaLLSa9M945.jpg\"},{\"color\":\"金色\",\"url\":\"http://192.168.192.132/group1/M00/00/03/wKiOi1qvMBGAPt5xAAD6nNM0jms672.jpg\"}]','手机 x 1 , 充电器 x 1, 耳机 x 1','质保三年'),(149187842867948,NULL,NULL,'[]','手机x1 , 说明书 x 1','质保三年'),(149187842867949,'[]','[{\"text\":\"内存大小\"},{\"text\":\"颜色\"}]','[]',NULL,NULL),(149187842867950,'[{\"attributeName\":\"网络\",\"attributeValue\":[\"移动3G\",\"电信4G\"]},{\"attributeName\":\"机身内存\",\"attributeValue\":[\"64G\",\"128G\"]}]','[{\"text\":\"内存大小\",\"value\":\"6G\"},{\"text\":\"颜色\",\"value\":\"白色\"}]','[{\"color\":\"白色\",\"url\":\"http://192.168.192.132/group1/M00/00/04/wKiOklrSmiGAXGqvAAE05ISJidY899.jpg\"},{\"color\":\"白色\",\"url\":\"http://192.168.192.132/group1/M00/00/04/wKiOklrSmi6AAA04AAE05ISJidY233.jpg\"}]','手机 x 1','无'),(149187842867951,NULL,NULL,'[]','11','11'),(149187842867952,NULL,NULL,'[]','222','222'),(149187842867953,'[{\"attributeName\":\"网络\",\"attributeValue\":[\"电信4G\",\"移动3G\"]},{\"attributeName\":\"机身内存\",\"attributeValue\":[\"32G\",\"64G\"]}]','[{\"text\":\"内存大小\",\"value\":\"64G\"},{\"text\":\"颜色\",\"value\":\"棕色\"}]','[{\"color\":\"黑色\",\"url\":\"http://192.168.192.132/group1/M00/00/04/wKiOklsnFQyAbyq_AAEMfD4pHs0994.png\"},{\"color\":\"白色\",\"url\":\"http://192.168.192.132/group1/M00/00/04/wKiOklsnFSeAI7PIAABBIjJcuLQ800.png\"}]','手机x1 ， 充电器x1 ， 耳机x1','三年质保'),(149187842867954,'[{\"attributeValue\":[\"电信4G\",\"移动3G\"],\"attributeName\":\"网络\"},{\"attributeValue\":[\"64G\",\"128G\"],\"attributeName\":\"机身内存\"}]','[{\"text\":\"内存大小\",\"value\":\"\"},{\"text\":\"颜色\",\"value\":\"\"}]','[{\"color\":\"骚气粉\",\"url\":\"http://192.168.192.132/group1/M00/00/04/wKiOklsw0HKANpYTAAGpceqxxyo899.jpg\"},{\"color\":\"骚气粉\",\"url\":\"http://192.168.192.132/group1/M00/00/04/wKiOklsw0HyAfepSAAF6OSRRQ2Q434.jpg\"},{\"color\":\"骚气粉\",\"url\":\"http://192.168.192.132/group1/M00/00/04/wKiOklsw0ISAGy17AADGzjB6yjQ296.jpg\"},{\"color\":\"骚气粉\",\"url\":\"http://192.168.192.132/group1/M00/00/04/wKiOklsw0JCAcnYFAADhXT4920Q060.jpg\"}]','主机x1、耳机x1、数据线x1、充电器x1、SIM卡通针x1、保护套x1、产品信息手册及保修卡x1','三年质保');

INSERT INTO tb_goods_item (id, title, price, stock_count, num, barcode, image, categoryId, status, create_time, update_time, item_sn, cost_pirce, market_price, is_default, goods_id, seller_id, cart_thumbnail, category, brand, spec, seller) VALUES (536563,'new2 - 阿尔卡特 (OT-927) 炭黑 联通3G手机 双卡双待',299000.00,NULL,99999,'','http://img12.360buyimg.com/n1/s450x450_jfs/t3034/299/2060854617/119711/577e85cb/57d11b6cN1fd1194d.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'手机','阿尔卡特','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','阿尔卡特'),(562379,'new8- 三星 W999 黑色 电信3G手机 双卡双待双通',11.00,NULL,99999,'','http://img10.360buyimg.com/n1/s450x450_jfs/t3457/294/236823024/102048/c97f5825/58072422Ndd7e66c4.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'手机','三星','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','三星'),(605616,'阿尔卡特 (OT-979) 冰川白 联通3G手机',309.00,NULL,99999,NULL,'http://img12.360buyimg.com/n1/s450x450_jfs/t3034/299/2060854617/119711/577e85cb/57d11b6cN1fd1194d.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867913,'1',NULL,'手机','阿尔卡特','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','阿尔卡特'),(635906,'阿尔卡特 (OT-927) 单电版 炭黑 联通3G手机 双卡双待',249.00,NULL,99999,NULL,'http://img12.360buyimg.com/n1/s450x450_jfs/t3034/299/2060854617/119711/577e85cb/57d11b6cN1fd1194d.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867913,'1',NULL,'手机','阿尔卡特','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','阿尔卡特'),(679532,'阿尔卡特 (OT-986+) 玫红 AK47 加强版 联通3G手机',499.00,NULL,99999,NULL,'http://img12.360buyimg.com/n1/s450x450_jfs/t3034/299/2060854617/119711/577e85cb/57d11b6cN1fd1194d.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867913,'1',NULL,'手机','阿尔卡特','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','阿尔卡特'),(679533,'阿尔卡特 (OT-986+) 曜石黑 AK47 加强版 联通3G手机',499.00,NULL,99999,NULL,'http://img12.360buyimg.com/n1/s450x450_jfs/t3034/299/2060854617/119711/577e85cb/57d11b6cN1fd1194d.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867914,'1',NULL,'手机','阿尔卡特','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','阿尔卡特'),(691300,'三星 B9120 钛灰色 联通3G手机 双卡双待双通',4399.00,NULL,99999,NULL,'http://img10.360buyimg.com/n1/s450x450_jfs/t3457/294/236823024/102048/c97f5825/58072422Ndd7e66c4.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867914,'1',NULL,'手机','三星','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','三星'),(738388,'三星 Note II (N7100) 云石白 联通3G手机',1699.00,NULL,99999,NULL,'http://img10.360buyimg.com/n1/s450x450_jfs/t3457/294/236823024/102048/c97f5825/58072422Ndd7e66c4.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867914,'1',NULL,'手机','三星','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','三星'),(741524,'三星 Note II (N7100) 钛金灰 联通3G手机',1699.00,NULL,99999,NULL,'http://img10.360buyimg.com/n1/s450x450_jfs/t3457/294/236823024/102048/c97f5825/58072422Ndd7e66c4.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867915,'1',NULL,'手机','三星','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','三星'),(816448,'三星 Note II (N7100) 钻石粉 联通3G手机',1699.00,NULL,99999,NULL,'http://img10.360buyimg.com/n1/s450x450_jfs/t3457/294/236823024/102048/c97f5825/58072422Ndd7e66c4.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867916,'1',NULL,'手机','三星','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','三星'),(816753,'夏普（SHARP）LCD-46DS40A 46英寸 日本原装液晶面板 智能全高清液晶电视',3799.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/jfs/t3514/213/2256693815/416437/1bbb4c23/584cfbbfN25d205dd.jpg',76,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867916,'1',NULL,'平板电视','夏普','{\"电视屏幕尺寸\":\"46英寸\"}','夏普'),(830972,'飞利浦 老人手机 (X2560) 深情蓝 移动联通2G手机 双卡双待',489.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/s450x450_jfs/t3115/243/2876210567/110536/f736e20b/57e7e8dbN1d7d7f90.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867916,'1',NULL,'手机','飞利浦','{\"机身内存\":\"16G\",\"网络\":\"联通2G\"}','飞利浦'),(832739,'中兴 U288 珠光白 移动3G手机',199.00,NULL,99999,NULL,'http://img12.360buyimg.com/n1/s450x450_jfs/t3034/299/2060854617/119711/577e85cb/57d11b6cN1fd1194d.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867917,'1',NULL,'手机','中兴','{\"机身内存\":\"16G\",\"网络\":\"移动3G\"}','中兴'),(844022,'三星 SCH-W899 亮金色 电信3G手机 双卡双待双通',2999.00,NULL,99999,NULL,'http://img10.360buyimg.com/n1/s450x450_jfs/t3457/294/236823024/102048/c97f5825/58072422Ndd7e66c4.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867917,'1',NULL,'手机','三星','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','三星'),(847276,'飞利浦 老人手机 (X2560) 喜庆红 移动联通2G手机 双卡双待',489.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/s450x450_jfs/t3115/243/2876210567/110536/f736e20b/57e7e8dbN1d7d7f90.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867917,'1',NULL,'手机','飞利浦','{\"机身内存\":\"16G\",\"网络\":\"联通2G\"}','飞利浦'),(847278,'飞利浦 老人手机 (X2560) 硬朗黑 移动联通2G手机 双卡双待',469.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/s450x450_jfs/t3115/243/2876210567/110536/f736e20b/57e7e8dbN1d7d7f90.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867918,'1',NULL,'手机','飞利浦','{\"机身内存\":\"16G\",\"网络\":\"联通2G\"}','飞利浦'),(855739,'三星 Galaxy S4 (I9500)16G版 皓月白 联通3G手机',1888.00,NULL,99999,NULL,'http://img10.360buyimg.com/n1/s450x450_jfs/t3457/294/236823024/102048/c97f5825/58072422Ndd7e66c4.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867918,'1',NULL,'手机','三星','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','三星'),(856645,'三星 Galaxy S4 (I9500) 16G版 星空黑 联通3G手机',1888.00,NULL,99999,NULL,'http://img10.360buyimg.com/n1/s450x450_jfs/t3457/294/236823024/102048/c97f5825/58072422Ndd7e66c4.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867919,'1',NULL,'手机','三星','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','三星'),(858025,'三星 I8552 白色 联通3G手机 双卡双待',799.00,NULL,99999,NULL,'http://img10.360buyimg.com/n1/s450x450_jfs/t3457/294/236823024/102048/c97f5825/58072422Ndd7e66c4.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867920,'1',NULL,'手机','三星','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','三星'),(860275,'长虹（CHANGHONG） 3D51C1080i 51英寸 快门式3D智能Android 电视（黑色）',2699.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/jfs/t3514/213/2256693815/416437/1bbb4c23/584cfbbfN25d205dd.jpg',76,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867921,'1',NULL,'平板电视','长虹','{\"电视屏幕尺寸\":\"51英寸\"}','长虹'),(868462,'LG 47LA6800-CA 47英寸 全高清智能3D液晶电视 （红色）',9999.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/jfs/t3514/213/2256693815/416437/1bbb4c23/584cfbbfN25d205dd.jpg',76,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867921,'1',NULL,'平板电视','LG','{\"电视屏幕尺寸\":\"47英寸\"}','LG'),(875722,'诺基亚(NOKIA) 1050 (RM-908) 黑色 移动联通2G手机',149.00,NULL,99999,NULL,'http://img10.360buyimg.com/n1/s450x450_jfs/t4111/232/1823016308/39740/762c40b1/589ab57bNc19054fc.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867921,'1',NULL,'手机','诺基亚','{\"机身内存\":\"16G\",\"网络\":\"联通2G\"}','诺基亚'),(875724,'诺基亚(NOKIA) 1050 (RM-908) 蓝色 移动联通2G手机',149.00,NULL,99999,NULL,'http://img10.360buyimg.com/n1/s450x450_jfs/t4111/232/1823016308/39740/762c40b1/589ab57bNc19054fc.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867922,'1',NULL,'手机','诺基亚','{\"机身内存\":\"16G\",\"网络\":\"联通2G\"}','诺基亚'),(883893,'联想 MA388 老人手机 星夜黑 移动联通2G手机 双卡双待',287.00,NULL,99999,NULL,'http://img14.360buyimg.com/n1/s450x450_jfs/t3736/175/107179033/114926/c0bca93e/57ff5de0N8e231194.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867922,'1',NULL,'手机','联想','{\"机身内存\":\"16G\",\"网络\":\"联通2G\"}','联想'),(907012,'海信（Hisense）LED42EC260JD 42英寸 窄边网络 LED电视（黑色）',2299.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/jfs/t3514/213/2256693815/416437/1bbb4c23/584cfbbfN25d205dd.jpg',76,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867922,'1',NULL,'平板电视','海信','{\"电视屏幕尺寸\":\"42英寸\"}','海信'),(909245,'酷派 8076D 咖啡棕 移动3G手机 双卡双待',199.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/s450x450_jfs/t3322/33/2284564501/73724/e133c724/584aa0e9N7dd07b46.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867923,'1',NULL,'手机','酷派','{\"机身内存\":\"16G\",\"网络\":\"移动3G\"}','酷派'),(912107,'创维(Skyworth)LED 42E5DHR 42英寸 海量影视资源智能网络平板液晶电视二代升级版(黑色)',2499.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/jfs/t3514/213/2256693815/416437/1bbb4c23/584cfbbfN25d205dd.jpg',76,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867923,'1',NULL,'平板电视','创维','{\"电视屏幕尺寸\":\"42英寸\"}','创维'),(915676,'联想 P780 极速版 深邃黑 联通3G手机 双卡双待',699.00,NULL,99999,NULL,'http://img14.360buyimg.com/n1/s450x450_jfs/t3736/175/107179033/114926/c0bca93e/57ff5de0N8e231194.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867923,'1',NULL,'手机','联想','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','联想'),(917460,'华为 P6 (P6-C00) 黑 电信3G手机 双卡双待双通',1288.00,NULL,99999,NULL,'http://img12.360buyimg.com/n1/s450x450_jfs/t3034/299/2060854617/119711/577e85cb/57d11b6cN1fd1194d.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867923,'1',NULL,'手机','华为','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','华为'),(917461,'华为 P6 (P6-C00) 白 电信3G手机 双卡双待双通',1299.00,NULL,99999,NULL,'http://img12.360buyimg.com/n1/s450x450_jfs/t3034/299/2060854617/119711/577e85cb/57d11b6cN1fd1194d.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867925,'1',NULL,'手机','华为','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','华为'),(917770,'华为 P6-C00 电信3G手机（粉色） CDMA2000/GSM 双模双待双通',1349.00,NULL,99999,NULL,'http://img12.360buyimg.com/n1/s450x450_jfs/t3034/299/2060854617/119711/577e85cb/57d11b6cN1fd1194d.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867925,'1',NULL,'手机','华为','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','华为'),(919669,'华为 Ascend P6 (P6-T00) 黑色 移动3G手机',1289.00,NULL,99999,NULL,'http://img12.360buyimg.com/n1/s450x450_jfs/t3034/299/2060854617/119711/577e85cb/57d11b6cN1fd1194d.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867926,'1',NULL,'手机','华为','{\"机身内存\":\"16G\",\"网络\":\"移动3G\"}','华为'),(925237,'三星 Galaxy S4 (I9502) 16G版 蓝色 联通3G手机 双卡双待双通',1899.00,NULL,99999,NULL,'http://img10.360buyimg.com/n1/s450x450_jfs/t3457/294/236823024/102048/c97f5825/58072422Ndd7e66c4.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867924,'1',NULL,'手机','三星','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','三星'),(927779,'海尔统帅（Leader）LE39MUF5 39英寸 MHL传屏 LED平板电视（黑色）',1999.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/jfs/t3514/213/2256693815/416437/1bbb4c23/584cfbbfN25d205dd.jpg',76,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867927,'1',NULL,'平板电视','海尔','{\"电视屏幕尺寸\":\"39英寸\"}','海尔'),(929734,'三星 I8558 白色 移动3G手机 双卡双待',759.00,NULL,99999,NULL,'http://img10.360buyimg.com/n1/s450x450_jfs/t3457/294/236823024/102048/c97f5825/58072422Ndd7e66c4.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867927,'1',NULL,'手机','三星','{\"机身内存\":\"16G\",\"网络\":\"移动3G\"}','三星'),(931849,'飞利浦 (X1560) 黑色+香槟色 移动联通2G手机 双卡双待',369.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/s450x450_jfs/t3115/243/2876210567/110536/f736e20b/57e7e8dbN1d7d7f90.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867928,'1',NULL,'手机','飞利浦','{\"机身内存\":\"16G\",\"网络\":\"联通2G\"}','飞利浦'),(936920,'夏普（SHARP）LCD-52DS70A 52英寸 日本原装液晶面板 3D Android操作系统智能液晶电视',6999.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/jfs/t3514/213/2256693815/416437/1bbb4c23/584cfbbfN25d205dd.jpg',76,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867928,'1',NULL,'平板电视','夏普','{\"电视屏幕尺寸\":\"52英寸\"}','夏普'),(941189,'TCL L32F3301B 32英寸 窄边蓝光USB播放LED电视(黑色）',1398.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/jfs/t3514/213/2256693815/416437/1bbb4c23/584cfbbfN25d205dd.jpg',76,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867928,'1',NULL,'平板电视','TCL','{\"电视屏幕尺寸\":\"32英寸\"}','TCL'),(951305,'三星 Galaxy S4 (I9502) 16G版 粉色 联通3G手机 双卡双待双通',1799.00,NULL,99999,NULL,'http://img10.360buyimg.com/n1/s450x450_jfs/t3457/294/236823024/102048/c97f5825/58072422Ndd7e66c4.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867929,'1',NULL,'手机','三星','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','三星'),(960138,'三星 I8558 灰色 移动3G手机 双卡双待',759.00,NULL,99999,NULL,'http://img10.360buyimg.com/n1/s450x450_jfs/t3457/294/236823024/102048/c97f5825/58072422Ndd7e66c4.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867930,'1',NULL,'手机','三星','{\"机身内存\":\"16G\",\"网络\":\"移动3G\"}','三星'),(967021,'TCL 老人手机 (i310) 暗夜黑 移动联通2G手机',199.00,NULL,99999,NULL,'http://img14.360buyimg.com/n1/s450x450_jfs/t3532/159/131329856/208385/d2e05067/58004df9Ncaaf71cc.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867931,'1',NULL,'手机','TCL','{\"机身内存\":\"16G\",\"网络\":\"联通2G\"}','TCL'),(968097,'长虹（CHANGHONG） LED32C2JDi 32英寸 安卓智能LED液晶电视（黑色）',1499.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/jfs/t3514/213/2256693815/416437/1bbb4c23/584cfbbfN25d205dd.jpg',76,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867931,'1',NULL,'平板电视','长虹','{\"电视屏幕尺寸\":\"32英寸\"}','长虹'),(968184,'索尼(SONY) Xperia Z1 (L39h) 黑色 联通3G手机',1938.00,NULL,99999,NULL,'http://img12.360buyimg.com/n1/s450x450_jfs/t3034/299/2060854617/119711/577e85cb/57d11b6cN1fd1194d.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867932,'1',NULL,'手机','索尼','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','索尼'),(968185,'索尼(SONY) Xperia Z1 (L39h) 白色 联通3G手机',1938.00,NULL,99999,NULL,'http://img12.360buyimg.com/n1/s450x450_jfs/t3034/299/2060854617/119711/577e85cb/57d11b6cN1fd1194d.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867932,'1',NULL,'手机','索尼','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','索尼'),(968188,'索尼(SONY) Xperia Z1 (L39h) 紫色 联通3G手机',1928.00,NULL,99999,NULL,'http://img12.360buyimg.com/n1/s450x450_jfs/t3034/299/2060854617/119711/577e85cb/57d11b6cN1fd1194d.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867932,'1',NULL,'手机','索尼','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','索尼'),(968189,'索尼(SONY) Xperia Z Ultra (XL39h) 黑色 联通3G手机',1698.00,NULL,99999,NULL,'http://img12.360buyimg.com/n1/s450x450_jfs/t3034/299/2060854617/119711/577e85cb/57d11b6cN1fd1194d.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867933,'1',NULL,'手机','索尼','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','索尼'),(968191,'索尼(SONY) Xperia Z Ultra (XL39h) 紫色 联通3G手机',1778.00,NULL,99999,NULL,'http://img12.360buyimg.com/n1/s450x450_jfs/t3034/299/2060854617/119711/577e85cb/57d11b6cN1fd1194d.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867933,'1',NULL,'手机','索尼','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','索尼'),(971047,'联想 S820e 红色 电信3G手机 双卡双待',498.00,NULL,99999,NULL,'http://img14.360buyimg.com/n1/s450x450_jfs/t3736/175/107179033/114926/c0bca93e/57ff5de0N8e231194.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867933,'1',NULL,'手机','联想','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','联想'),(971050,'联想 S820e 白色 电信3G手机 双卡双待',498.00,NULL,99999,NULL,'http://img14.360buyimg.com/n1/s450x450_jfs/t3736/175/107179033/114926/c0bca93e/57ff5de0N8e231194.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867934,'1',NULL,'手机','联想','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','联想'),(972627,'金立 商务翻盖 (A809) 绅士黑 联通移动2G手机 双卡双待单通',599.00,NULL,99999,NULL,'http://img12.360buyimg.com/n1/s450x450_jfs/t3034/299/2060854617/119711/577e85cb/57d11b6cN1fd1194d.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867934,'1',NULL,'手机','金立','{\"机身内存\":\"16G\",\"网络\":\"移动2G\"}','金立'),(973267,'优快（U&K） U97 四防对讲手机',1980.00,NULL,99999,NULL,'http://img12.360buyimg.com/n1/s450x450_jfs/t3034/299/2060854617/119711/577e85cb/57d11b6cN1fd1194d.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867934,'1',NULL,'手机','中国移动','{\"机身内存\":\"16G\",\"网络\":\"双卡\"}','中国移动'),(973825,'飞利浦 (X5500) 奢华黑 移动联通2G手机 双卡双待',799.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/s450x450_jfs/t3115/243/2876210567/110536/f736e20b/57e7e8dbN1d7d7f90.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867935,'1',NULL,'手机','飞利浦','{\"机身内存\":\"16G\",\"网络\":\"联通2G\"}','飞利浦'),(973862,'三星 Galaxy Note3 (N9009) 16G版 炫酷黑 电信3G手机 双卡双待双通',3099.00,NULL,99999,NULL,'http://img10.360buyimg.com/n1/s450x450_jfs/t3457/294/236823024/102048/c97f5825/58072422Ndd7e66c4.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867935,'1',NULL,'手机','三星','{\"机身内存\":\"16G\",\"网络\":\"电信3G\"}','三星'),(974401,'苹果(Apple) iPhone 5s (A1533) 16GB 银色 电信3G手机',4099.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/s450x450_jfs/t3160/284/298314156/78089/fd106c0c/57b00f93Nc77f215f.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867936,'1',NULL,'手机','苹果','{\"机身内存\":\"16G\",\"网络\":\"电信3G\"}','苹果'),(975023,'三星 Galaxy Note 3 (N9002) 简约白 联通3G手机 双卡双待双通',2799.00,NULL,99999,NULL,'http://img10.360buyimg.com/n1/s450x450_jfs/t3457/294/236823024/102048/c97f5825/58072422Ndd7e66c4.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867936,'1',NULL,'手机','三星','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','三星'),(975024,'三星 Galaxy Note 3 (N9002) 炫酷黑 联通3G手机 双卡双待双通',2799.00,NULL,99999,NULL,'http://img10.360buyimg.com/n1/s450x450_jfs/t3457/294/236823024/102048/c97f5825/58072422Ndd7e66c4.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867937,'1',NULL,'手机','三星','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','三星'),(975101,'长虹（CHANGHONG） LED42C2JDi 42英寸 安卓智能LED液晶电视（黑色）',2399.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/jfs/t3514/213/2256693815/416437/1bbb4c23/584cfbbfN25d205dd.jpg',76,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867938,'1',NULL,'平板电视','长虹','{\"电视屏幕尺寸\":\"42英寸\"}','长虹'),(975641,'苹果(Apple) iPhone 5s (A1533) 16GB 金色 电信3G手机',4099.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/s450x450_jfs/t3160/284/298314156/78089/fd106c0c/57b00f93Nc77f215f.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867938,'1',NULL,'手机','苹果','{\"机身内存\":\"16G\",\"网络\":\"电信3G\"}','苹果'),(976898,'苹果 iPhone 4S 8G 白色 联通3G手机',1999.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/s450x450_jfs/t3712/359/495301542/119558/da44ceda/580cb3adN14e04e47.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867939,'1',NULL,'手机','苹果','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','苹果'),(979072,'康佳（KONKA） LED42J39AW 42英寸 超薄安卓智能液晶电视（黑色）',2598.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/jfs/t3514/213/2256693815/416437/1bbb4c23/584cfbbfN25d205dd.jpg',76,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867939,'1',NULL,'平板电视','康佳','{\"电视屏幕尺寸\":\"42英寸\"}','康佳'),(979281,'三星 W789 奢华金 电信3G手机 双卡双待双通',2999.00,NULL,99999,NULL,'http://img10.360buyimg.com/n1/s450x450_jfs/t3457/294/236823024/102048/c97f5825/58072422Ndd7e66c4.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867938,'1',NULL,'手机','三星','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','三星'),(981123,'联想 A516 荧光粉 联通3G手机 双卡双待',399.00,NULL,99999,NULL,'http://img14.360buyimg.com/n1/s450x450_jfs/t3736/175/107179033/114926/c0bca93e/57ff5de0N8e231194.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'手机','联想','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','联想'),(981821,'苹果(Apple) iPhone 4s 8GB 白色 联通3G手机',1999.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/s450x450_jfs/t3712/359/495301542/119558/da44ceda/580cb3adN14e04e47.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'手机','苹果','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','苹果'),(981822,'苹果(Apple) iPhone 4s 8GB 黑色 联通3G手机',1999.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/s450x450_jfs/t3712/359/495301542/119558/da44ceda/580cb3adN14e04e47.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'手机','苹果','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','苹果'),(983248,'诺基亚(NOKIA) 107 (RM-961) 红色 移动联通2G手机 双卡双待',168.00,NULL,99999,NULL,'http://img10.360buyimg.com/n1/s450x450_jfs/t4111/232/1823016308/39740/762c40b1/589ab57bNc19054fc.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'手机','诺基亚','{\"机身内存\":\"16G\",\"网络\":\"联通2G\"}','诺基亚'),(983252,'诺基亚(NOKIA) 107 (RM-961) 白色 移动联通2G手机 双卡双待',168.00,NULL,99999,NULL,'http://img10.360buyimg.com/n1/s450x450_jfs/t4111/232/1823016308/39740/762c40b1/589ab57bNc19054fc.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'手机','诺基亚','{\"机身内存\":\"16G\",\"网络\":\"联通2G\"}','诺基亚'),(983253,'诺基亚(NOKIA) 107 (RM-961) 黑色 移动联通2G手机 双卡双待',168.00,NULL,99999,NULL,'http://img10.360buyimg.com/n1/s450x450_jfs/t4111/232/1823016308/39740/762c40b1/589ab57bNc19054fc.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'手机','诺基亚','{\"机身内存\":\"16G\",\"网络\":\"联通2G\"}','诺基亚'),(983521,'联想 VIBE X (S960)铂雅银 联通3G手机',699.00,NULL,99999,NULL,'http://img14.360buyimg.com/n1/s450x450_jfs/t3736/175/107179033/114926/c0bca93e/57ff5de0N8e231194.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'手机','联想','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','联想'),(985058,'派信（PISIN） WO1 NanoSmart 智能手表手机（蓝色）',350.00,NULL,99999,NULL,'http://img12.360buyimg.com/n1/jfs/t2782/359/4077589024/336381/fde73bb/57aa9388N50f56987.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'手机','派信','{\"机身内存\":\"16G\",\"网络\":\"双卡\"}','派信'),(985059,'派信（PISIN） WO1 NanoSmart 智能手表手机（红色）',350.00,NULL,99999,NULL,'http://img12.360buyimg.com/n1/jfs/t2782/359/4077589024/336381/fde73bb/57aa9388N50f56987.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'手机','派信','{\"机身内存\":\"16G\",\"网络\":\"双卡\"}','派信'),(988634,'长虹（CHANGHONG）LED39C2080i 39英寸智能安卓LED液晶电视（黑色）',1999.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/jfs/t3514/213/2256693815/416437/1bbb4c23/584cfbbfN25d205dd.jpg',76,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'平板电视','长虹','{\"电视屏幕尺寸\":\"39英寸\"}','长虹'),(988753,'联想 A516 白色 联通3G手机 双卡双待',399.00,NULL,99999,NULL,'http://img14.360buyimg.com/n1/s450x450_jfs/t3736/175/107179033/114926/c0bca93e/57ff5de0N8e231194.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'手机','联想','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','联想'),(988833,'诺基亚(NOKIA) 108 (RM-944) 黑色 移动联通2G手机 双卡双待',189.00,NULL,99999,NULL,'http://img10.360buyimg.com/n1/s450x450_jfs/t4111/232/1823016308/39740/762c40b1/589ab57bNc19054fc.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'手机','诺基亚','{\"机身内存\":\"16G\",\"网络\":\"联通2G\"}','诺基亚'),(988834,'诺基亚(NOKIA) 108 (RM-944) 红色 移动联通2G手机 双卡双待',189.00,NULL,99999,NULL,'http://img10.360buyimg.com/n1/s450x450_jfs/t4111/232/1823016308/39740/762c40b1/589ab57bNc19054fc.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'手机','诺基亚','{\"机身内存\":\"16G\",\"网络\":\"联通2G\"}','诺基亚'),(989026,'酷派 7231 黑色 联通3G手机 双卡双待',259.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/s450x450_jfs/t3322/33/2284564501/73724/e133c724/584aa0e9N7dd07b46.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'手机','酷派','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','酷派'),(990723,'TCL LE50D59 50英寸 超窄边内置WIFI安卓智能液晶电视（黑色）',3299.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/jfs/t3514/213/2256693815/416437/1bbb4c23/584cfbbfN25d205dd.jpg',76,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'平板电视','TCL','{\"电视屏幕尺寸\":\"50英寸\"}','TCL'),(990724,'TCL LE32D59 32英寸 安卓4.0 超窄边智能LED液晶电视（黑色）',1598.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/jfs/t3514/213/2256693815/416437/1bbb4c23/584cfbbfN25d205dd.jpg',76,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'平板电视','TCL','{\"电视屏幕尺寸\":\"32英寸\"}','TCL'),(997643,'长虹（CHANGHONG）LED50C2080i 50英寸智能安卓LED液晶电视（黑色）',3399.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/jfs/t3514/213/2256693815/416437/1bbb4c23/584cfbbfN25d205dd.jpg',76,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'平板电视','长虹','{\"电视屏幕尺寸\":\"50英寸\"}','长虹'),(997966,'诺基亚(NOKIA) 106 (RM-962) 红色 移动联通2G手机',149.00,NULL,99999,NULL,'http://img10.360buyimg.com/n1/s450x450_jfs/t4111/232/1823016308/39740/762c40b1/589ab57bNc19054fc.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'手机','诺基亚','{\"机身内存\":\"16G\",\"网络\":\"联通2G\"}','诺基亚'),(997967,'诺基亚(NOKIA) 106 (RM-962) 黑色 移动联通2G手机',149.00,NULL,99999,NULL,'http://img10.360buyimg.com/n1/s450x450_jfs/t4111/232/1823016308/39740/762c40b1/589ab57bNc19054fc.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'手机','诺基亚','{\"机身内存\":\"16G\",\"网络\":\"联通2G\"}','诺基亚'),(998692,'夏普（SHARP）LCD-52DS51A 52英寸 日本原装液晶面板 内置WIFI智能全高清液晶电视',5499.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/jfs/t3514/213/2256693815/416437/1bbb4c23/584cfbbfN25d205dd.jpg',76,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'平板电视','夏普','{\"电视屏幕尺寸\":\"52英寸\"}','夏普'),(1000508,'TCL Hero N3 (Y910T) 16GB 雪山白 移动3G手机 双卡双待',1099.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/s450x450_jfs/t2278/328/1482029120/347965/7755349f/565e97aaN5710a07d.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'手机','TCL','{\"机身内存\":\"16G\",\"网络\":\"移动3G\"}','TCL'),(1002523,'飞利浦（PHILIPS） 65PFL8730/T3 65英寸 3D全高清LED智能电视',16999.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/jfs/t3514/213/2256693815/416437/1bbb4c23/584cfbbfN25d205dd.jpg',76,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'平板电视','飞利浦','{\"电视屏幕尺寸\":\"65英寸\"}','飞利浦'),(1002986,'创维(Skyworth)LED 32E5ERS 32英寸 窄边蓝光节能平板液晶电视(银色)',1388.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/jfs/t3514/213/2256693815/416437/1bbb4c23/584cfbbfN25d205dd.jpg',76,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'平板电视','创维','{\"电视屏幕尺寸\":\"32英寸\"}','创维'),(1008825,'TCL L40F3301B 40英寸 超窄边框蓝光LED液晶电视（珠光黑）',1899.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/jfs/t3514/213/2256693815/416437/1bbb4c23/584cfbbfN25d205dd.jpg',76,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'平板电视','TCL','{\"电视屏幕尺寸\":\"40英寸\"}','TCL'),(1009199,'诺基亚(NOKIA) 106 (RM-962) 白色 移动联通2G手机',149.00,NULL,99999,NULL,'http://img10.360buyimg.com/n1/s450x450_jfs/t4111/232/1823016308/39740/762c40b1/589ab57bNc19054fc.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'手机','诺基亚','{\"机身内存\":\"16G\",\"网络\":\"联通2G\"}','诺基亚'),(1009233,'诺基亚(NOKIA) 108 (RM-944) 白色 移动联通2G手机 双卡双待',189.00,NULL,99999,NULL,'http://img10.360buyimg.com/n1/s450x450_jfs/t4111/232/1823016308/39740/762c40b1/589ab57bNc19054fc.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'手机','诺基亚','{\"机身内存\":\"16G\",\"网络\":\"联通2G\"}','诺基亚'),(1009234,'诺基亚(NOKIA) 108 (RM-944) 蓝色 移动联通2G手机 双卡双待',189.00,NULL,99999,NULL,'http://img10.360buyimg.com/n1/s450x450_jfs/t4111/232/1823016308/39740/762c40b1/589ab57bNc19054fc.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'手机','诺基亚','{\"机身内存\":\"16G\",\"网络\":\"联通2G\"}','诺基亚'),(1009237,'诺基亚(NOKIA) 108 (RM-944) 黄色 移动联通2G手机 双卡双待',189.00,NULL,99999,NULL,'http://img10.360buyimg.com/n1/s450x450_jfs/t4111/232/1823016308/39740/762c40b1/589ab57bNc19054fc.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'手机','诺基亚','{\"机身内存\":\"16G\",\"网络\":\"联通2G\"}','诺基亚'),(1014989,'小辣椒 3 (LA3-E）辛辣黑 电信3G手机 双卡双待',599.00,NULL,99999,NULL,'http://img12.360buyimg.com/n1/s450x450_jfs/t3034/299/2060854617/119711/577e85cb/57d11b6cN1fd1194d.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'手机','中国移动','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','中国移动'),(1018006,'TCL (i110) 暗夜黑 移动联通2G手机 双卡双待',148.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/s450x450_jfs/t2278/328/1482029120/347965/7755349f/565e97aaN5710a07d.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'手机','TCL','{\"机身内存\":\"16G\",\"网络\":\"联通2G\"}','TCL'),(1023433,'苹果(Apple) iPhone 5s (A1518) 16GB 金色 移动4G手机',3999.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/s450x450_jfs/t3160/284/298314156/78089/fd106c0c/57b00f93Nc77f215f.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'手机','苹果','{\"机身内存\":\"16G\",\"网络\":\"移动4G\"}','苹果'),(1023437,'苹果(Apple) iPhone 5s (A1518) 16GB 银色 移动4G手机',4099.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/s450x450_jfs/t3160/284/298314156/78089/fd106c0c/57b00f93Nc77f215f.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'手机','苹果','{\"机身内存\":\"16G\",\"网络\":\"移动4G\"}','苹果'),(1023438,'苹果(Apple) iPhone 5s (A1518) 16GB 深空灰色 移动4G手机',4099.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/s450x450_jfs/t3160/284/298314156/78089/fd106c0c/57b00f93Nc77f215f.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'手机','苹果','{\"机身内存\":\"16G\",\"网络\":\"移动4G\"}','苹果'),(1023752,'飞利浦 老人手机 (W8578) 黑色 联通3G手机 双卡双待',1799.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/s450x450_jfs/t3115/243/2876210567/110536/f736e20b/57e7e8dbN1d7d7f90.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'手机','飞利浦','{\"机身内存\":\"16G\",\"网络\":\"联通3G\"}','飞利浦'),(1025149,'飞利浦（PHILIPS） 32PFL3045/T3 32英寸 高清LED液晶电视（黑色）',1399.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/jfs/t3514/213/2256693815/416437/1bbb4c23/584cfbbfN25d205dd.jpg',76,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'平板电视','飞利浦','{\"电视屏幕尺寸\":\"32英寸\"}','飞利浦'),(1026253,'酷派 8085Q 淡雅金 移动3G手机',289.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/s450x450_jfs/t3322/33/2284564501/73724/e133c724/584aa0e9N7dd07b46.jpg',560,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'手机','酷派','{\"机身内存\":\"16G\",\"网络\":\"移动3G\"}','酷派'),(1026324,'东芝（TOSHIBA） 42L1353C 42英寸 全高清 LED 液晶电视（黑色）',2599.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/jfs/t3514/213/2256693815/416437/1bbb4c23/584cfbbfN25d205dd.jpg',76,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'平板电视','东芝','{\"电视屏幕尺寸\":\"42英寸\"}','东芝'),(1026325,'东芝（TOSHIBA） 39L2303C 39英寸 高清LED 液晶电视（黑色）',2088.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/jfs/t3514/213/2256693815/416437/1bbb4c23/584cfbbfN25d205dd.jpg',76,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'平板电视','东芝','{\"电视屏幕尺寸\":\"39英寸\"}','东芝'),(1027317,'飞利浦（PHILIPS） 50PFL3040/T3 50英寸 全高清LED液晶电视(黑色）',3499.00,NULL,99999,NULL,'http://img11.360buyimg.com/n1/jfs/t3514/213/2256693815/416437/1bbb4c23/584cfbbfN25d205dd.jpg',76,'1','2022-01-02 11:36:17','2022-01-02 11:36:17',NULL,NULL,NULL,NULL,149187842867912,'1',NULL,'平板电视','飞利浦','{\"电视屏幕尺寸\":\"50英寸\"}','飞利浦');


INSERT INTO tb_order_item (id, item_id, goods_id, order_id, title, price, num, total_fee, pic_path, seller_id) VALUES (918159799198212097,1369280,149187842867960,918159799198212096,'精品半身裙（秋款打折） 移动3G 16G',200.00,2,400.00,'http://192.168.25.133/group1/M00/00/00/wKgZhVnGbYuAO6AHAAjlKdWCzvg253.jpg','qiandu'),(918334996291301377,1369280,149187842867960,918334996291301376,'精品半身裙（秋款打折） 移动3G 16G',200.00,8,1600.00,'http://192.168.25.133/group1/M00/00/00/wKgZhVnGbYuAO6AHAAjlKdWCzvg253.jpg','qiandu'),(918334996622651392,1369281,149187842867960,918334996291301376,'精品半身裙（秋款打折） 移动3G 32G',202.00,2,404.00,'http://192.168.25.133/group1/M00/00/00/wKgZhVnGbYuAO6AHAAjlKdWCzvg253.jpg','qiandu'),(918334996698148865,1369278,1,918334996698148864,'【联通合约惠机】小米 红米Note 增强版 象牙白 联通4G手机',899.00,2,1798.00,'http://img12.360buyimg.com/n1/s450x450_jfs/t3034/299/2060854617/119711/577e85cb/57d11b6cN1fd1194d.jpg','yijia'),(918773289399160833,1369280,149187842867960,918773289399160832,'精品半身裙（秋款打折） 移动3G 16G',200.00,1,200.00,'http://192.168.25.133/group1/M00/00/00/wKgZhVnGbYuAO6AHAAjlKdWCzvg253.jpg','qiandu'),(918780408353546241,1369280,149187842867960,918780408353546240,'精品半身裙（秋款打折） 移动3G 16G',0.01,1,0.01,'http://192.168.25.133/group1/M00/00/00/wKgZhVnGbYuAO6AHAAjlKdWCzvg253.jpg','qiandu'),(918806410454654977,1369280,149187842867960,918806410454654976,'精品半身裙（秋款打折） 移动3G 16G',0.01,1,0.01,'http://192.168.25.133/group1/M00/00/00/wKgZhVnGbYuAO6AHAAjlKdWCzvg253.jpg','qiandu'),(918833485639081985,1369280,149187842867960,918833485639081984,'精品半身裙（秋款打折） 移动3G 16G',0.01,1,0.01,'http://192.168.25.133/group1/M00/00/00/wKgZhVnGbYuAO6AHAAjlKdWCzvg253.jpg','qiandu'),(918835712441212929,1369280,149187842867960,918835712441212928,'精品半身裙（秋款打折） 移动3G 16G',0.01,1,0.01,'http://192.168.25.133/group1/M00/00/00/wKgZhVnGbYuAO6AHAAjlKdWCzvg253.jpg','qiandu'),(919055624854081537,1369280,149187842867960,919055624854081536,'精品半身裙（秋款打折） 移动3G 16G',0.01,1,0.01,'http://192.168.25.133/group1/M00/00/00/wKgZhVnGbYuAO6AHAAjlKdWCzvg253.jpg','qiandu'),(919059760869863425,1369280,149187842867960,919059760869863424,'精品半身裙（秋款打折） 移动3G 16G',0.01,2,0.02,'http://192.168.25.133/group1/M00/00/00/wKgZhVnGbYuAO6AHAAjlKdWCzvg253.jpg','qiandu'),(992190237968957441,1369282,149187842867960,992190237968957440,'精品半身裙（秋款打折） 移动4G 16G',0.03,5,0.15,'http://192.168.25.133/group1/M00/00/00/wKgZhVnGbYuAO6AHAAjlKdWCzvg253.jpg','qiandu'),(992190238262558720,1369281,149187842867960,992190237968957440,'精品半身裙（秋款打折） 移动3G 32G',0.02,1,0.02,'http://192.168.25.133/group1/M00/00/00/wKgZhVnGbYuAO6AHAAjlKdWCzvg253.jpg','qiandu'),(992190947183820801,1369281,149187842867960,992190947183820800,'精品半身裙（秋款打折） 移动3G 32G',0.02,1,0.02,'http://192.168.25.133/group1/M00/00/00/wKgZhVnGbYuAO6AHAAjlKdWCzvg253.jpg','qiandu'),(992191916919488513,1369280,149187842867960,992191916919488512,'精品半身裙（秋款打折） 移动3G 16G',0.01,1,0.01,'http://192.168.25.133/group1/M00/00/00/wKgZhVnGbYuAO6AHAAjlKdWCzvg253.jpg','qiandu'),(992192064319913985,1369280,149187842867960,992192064319913984,'精品半身裙（秋款打折） 移动3G 16G',0.01,1,0.01,'http://192.168.25.133/group1/M00/00/00/wKgZhVnGbYuAO6AHAAjlKdWCzvg253.jpg','qiandu'),(992193598722146305,1369280,149187842867960,992193598722146304,'精品半身裙（秋款打折） 移动3G 16G',0.01,1,0.01,'http://192.168.25.133/group1/M00/00/00/wKgZhVnGbYuAO6AHAAjlKdWCzvg253.jpg','qiandu'),(992194631628226561,1369280,149187842867960,992194631628226560,'精品半身裙（秋款打折） 移动3G 16G',0.01,1,0.01,'http://192.168.25.133/group1/M00/00/00/wKgZhVnGbYuAO6AHAAjlKdWCzvg253.jpg','qiandu'),(992195664538501121,1369280,149187842867960,992195664538501120,'精品半身裙（秋款打折） 移动3G 16G',0.01,1,0.01,'http://192.168.25.133/group1/M00/00/00/wKgZhVnGbYuAO6AHAAjlKdWCzvg253.jpg','qiandu'),(992196116772552705,1369280,149187842867960,992196116772552704,'精品半身裙（秋款打折） 移动3G 16G',0.01,1,0.01,'http://192.168.25.133/group1/M00/00/00/wKgZhVnGbYuAO6AHAAjlKdWCzvg253.jpg','qiandu'),(992196968627306497,1369280,149187842867960,992196968627306496,'精品半身裙（秋款打折） 移动3G 16G',0.01,1,0.01,'http://192.168.25.133/group1/M00/00/00/wKgZhVnGbYuAO6AHAAjlKdWCzvg253.jpg','qiandu'),(992197105567137793,1369280,149187842867960,992197105567137792,'精品半身裙（秋款打折） 移动3G 16G',0.01,1,0.01,'http://192.168.25.133/group1/M00/00/00/wKgZhVnGbYuAO6AHAAjlKdWCzvg253.jpg','qiandu'),(992197263067447297,1369280,149187842867960,992197263067447296,'精品半身裙（秋款打折） 移动3G 16G',0.01,1,0.01,'http://192.168.25.133/group1/M00/00/00/wKgZhVnGbYuAO6AHAAjlKdWCzvg253.jpg','qiandu'),(992554565456887809,1369280,149187842867960,992554565456887808,'精品半身裙（秋款打折） 移动3G 16G',0.01,2,0.02,'http://192.168.25.133/group1/M00/00/00/wKgZhVnGbYuAO6AHAAjlKdWCzvg253.jpg','qiandu'),(992571196308455425,1369280,149187842867960,992571196308455424,'精品半身裙（秋款打折） 移动3G 16G',0.01,2,0.02,'http://192.168.25.133/group1/M00/00/00/wKgZhVnGbYuAO6AHAAjlKdWCzvg253.jpg','qiandu'),(992578873906429953,1369280,149187842867960,992578873906429952,'精品半身裙（秋款打折） 移动3G 16G',0.01,1,0.01,'http://192.168.25.133/group1/M00/00/00/wKgZhVnGbYuAO6AHAAjlKdWCzvg253.jpg','qiandu'),(992605539282190337,1369282,149187842867960,992605539282190336,'精品半身裙（秋款打折） 移动4G 16G',0.03,1,0.03,'http://192.168.25.133/group1/M00/00/00/wKgZhVnGbYuAO6AHAAjlKdWCzvg253.jpg','qiandu');

INSERT INTO tb_order_master (order_id, payment, payment_type, post_fee, status, create_time, update_time, payment_time, consign_time, end_time, close_time, shipping_name, shipping_code, user_id, buyer_message, buyer_nick, buyer_rate, receiver_province, receiver_city, receiver_region, receiver, expire, invoice_type, source_type, seller_id) VALUES (918159799198212096,400.00,'1',NULL,'1','2022-01-02 11:37:41','2022-01-02 11:37:41',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'350000','350100','350111','叶问',NULL,NULL,NULL,'qiandu'),(918334996291301376,2004.00,'2',NULL,'1','2022-01-02 11:37:41','2022-01-02 11:37:41',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'350000','350100','350111','李小龙',NULL,NULL,'2','qiandu'),(918334996698148864,1798.00,'2',NULL,'1','2022-01-02 11:37:41','2022-01-02 11:37:41',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'350000','350100','350111','李小龙',NULL,NULL,'2','yijia'),(918773289399160832,200.00,'1',NULL,'1','2022-01-02 11:37:41','2022-01-02 11:37:41',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'350000','350100','350111','李小龙',NULL,NULL,NULL,'qiandu'),(918780408353546240,0.01,'1',NULL,'2','2022-01-02 11:37:41','2022-01-02 11:37:41',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'350000','350100','350111','李小龙',NULL,NULL,NULL,'qiandu'),(918806410454654976,0.01,'1',NULL,'2','2022-01-02 11:37:41','2022-01-02 11:37:41',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'350000','350100','350111','李佳星',NULL,NULL,NULL,'qiandu'),(918833485639081984,0.01,'1',NULL,'1','2022-01-02 11:37:41','2022-01-02 11:37:41',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'350000','350100','350111','李佳星',NULL,NULL,NULL,'qiandu'),(918835712441212928,0.01,'1',NULL,'2','2022-01-02 11:37:41','2022-01-02 11:37:41',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'110000','110100','110108','李佳星',NULL,NULL,NULL,'qiandu'),(919055624854081536,0.01,'1',NULL,'1','2022-01-02 11:37:41','2022-01-02 11:37:41',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'110000','110100','110108','李佳星',NULL,NULL,'2','qiandu'),(919059760869863424,0.02,'1',NULL,'2','2022-01-02 11:37:41','2022-01-02 11:37:41',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'110000','110100','110108','李嘉诚',NULL,NULL,'2','qiandu'),(992190237968957440,0.17,'1',NULL,'1','2022-01-02 11:37:41','2022-01-02 11:37:41',NULL,NULL,NULL,NULL,NULL,NULL,'java18',NULL,NULL,NULL,'110000','110100','110108','叶问',NULL,NULL,'2',NULL),(992190947183820800,0.02,'1',NULL,'1','2022-01-02 11:37:41','2022-01-02 11:37:41',NULL,NULL,NULL,NULL,NULL,NULL,'java18',NULL,NULL,NULL,'110000','110100','110108','叶问',NULL,NULL,'2',NULL),(992191916919488512,0.01,'1',NULL,'1','2022-01-02 11:37:41','2022-01-02 11:37:41',NULL,NULL,NULL,NULL,NULL,NULL,'java18',NULL,NULL,NULL,'110000','110100','110108','叶问',NULL,NULL,'2',NULL),(992192064319913984,0.01,'1',NULL,'1','2022-01-02 11:37:41','2022-01-02 11:37:41',NULL,NULL,NULL,NULL,NULL,NULL,'java18',NULL,NULL,NULL,'110000','110100','110108','叶问',NULL,NULL,'2',NULL),(992193598722146304,0.01,'1',NULL,'1','2022-01-02 11:37:41','2022-01-02 11:37:41',NULL,NULL,NULL,NULL,NULL,NULL,'java18',NULL,NULL,NULL,'110000','110100','110108','叶问',NULL,NULL,'2',NULL),(992194631628226560,0.01,'1',NULL,'1','2022-01-02 11:37:41','2022-01-02 11:37:41',NULL,NULL,NULL,NULL,NULL,NULL,'java18',NULL,NULL,NULL,'110000','110100','110108','叶问',NULL,NULL,'2',NULL),(992195664538501120,0.01,'1',NULL,'1','2022-01-02 11:37:41','2022-01-02 11:37:41',NULL,NULL,NULL,NULL,NULL,NULL,'java18',NULL,NULL,NULL,'110000','110100','110108','叶问',NULL,NULL,'2',NULL),(992196116772552704,0.01,'1',NULL,'1','2022-01-02 11:37:41','2022-01-02 11:37:41',NULL,NULL,NULL,NULL,NULL,NULL,'java18',NULL,NULL,NULL,'110000','110100','110108','叶问',NULL,NULL,'2',NULL),(992196968627306496,0.01,'1',NULL,'1','2022-01-02 11:37:41','2022-01-02 11:37:41',NULL,NULL,NULL,NULL,NULL,NULL,'java18',NULL,NULL,NULL,'110000','110100','110108','叶问',NULL,NULL,'2',NULL),(992197105567137792,0.01,'1',NULL,'1','2022-01-02 11:37:41','2022-01-02 11:37:41',NULL,NULL,NULL,NULL,NULL,NULL,'java18',NULL,NULL,NULL,'110000','110100','110108','叶问',NULL,NULL,'2',NULL),(992197263067447296,0.01,'1',NULL,'1','2022-01-02 11:37:41','2022-01-02 11:37:41',NULL,NULL,NULL,NULL,NULL,NULL,'java18',NULL,NULL,NULL,'110000','110100','110108','叶问',NULL,NULL,'2',NULL),(992554565456887808,0.02,'1',NULL,'1','2022-01-02 11:37:41','2022-01-02 11:37:41',NULL,NULL,NULL,NULL,NULL,NULL,'java18',NULL,NULL,NULL,'110000','110100','110108','叶问',NULL,NULL,'2',NULL),(992571196308455424,0.02,'1',NULL,'1','2022-01-02 11:37:41','2022-01-02 11:37:41',NULL,NULL,NULL,NULL,NULL,NULL,'java18',NULL,NULL,NULL,'110000','110100','110108','叶问',NULL,NULL,'2',NULL),(992578873906429952,0.01,'1',NULL,'1','2022-01-02 11:37:41','2022-01-02 11:37:41',NULL,NULL,NULL,NULL,NULL,NULL,'java18',NULL,NULL,NULL,'110000','110100','110108','叶问',NULL,NULL,'2',NULL),(992605539282190336,0.03,'1',NULL,'1','2022-01-02 11:37:41','2022-01-02 11:37:41',NULL,NULL,NULL,NULL,NULL,NULL,'java18',NULL,NULL,NULL,'110000','110100','110108','叶问',NULL,NULL,'2',NULL);

INSERT INTO tb_order_pay_log (out_trade_no, create_time, pay_time, total_fee, user_id, transaction_id, trade_state, order_list, pay_type) VALUES ('1014520480276676608','2022-01-02 11:39:01','2022-01-02 11:39:01',21097900,'java20',NULL,'0','1014520479974686720','1'),('1014521147837906944','2022-01-02 11:39:01','2022-01-02 11:39:01',3099700,'java20',NULL,'0','1014521147812741120','1'),('1014662090717134848','2022-01-02 11:39:01','2022-01-02 11:39:01',21097900,'java20',NULL,'0','1014662090394173440','1'),('1014662230546841600','2022-01-02 11:39:01','2022-01-02 11:39:01',1099900,'java20',NULL,'0','1014662230521675776','1'),('1014758767050358784','2022-01-02 11:39:01','2022-01-02 11:39:01',999900,'java20',NULL,'0','1014758767025192960','1'),('1014759021980155904','2022-01-02 11:39:01','2022-01-02 11:39:01',999900,'java20',NULL,'0','1014759021959184384','1'),('1014766375954022400','2022-01-02 11:39:01','2022-01-02 11:39:01',4099600,'java20',NULL,'0','1014766375664615424','1'),('1014767824196861952','2022-01-02 11:39:01','2022-01-02 11:39:01',4199600,'java20',NULL,'0','1014767824171696128','1'),('1014768969397043200','2022-01-02 11:39:01','2022-01-02 11:39:01',6299400,'java20',NULL,'0','1014768969367683072','1'),('1105055662091534336','2022-01-02 11:39:01','2022-01-02 11:39:01',999900,'java34',NULL,'0','1105055661751795712','1'),('1149692937651617792','2022-01-02 11:39:01','2022-01-02 11:39:01',3,'deng',NULL,'0','1149692937240576000','1'),('918773291320152064','2022-01-02 11:39:01','2022-01-02 11:39:01',20000,'lijialong','4009852001201708268336481082','1','918773289399160832,918773289399160833','1'),('918780410236788736','2022-01-02 11:39:01','2022-01-02 11:39:01',1,'lijialong','4200000028201710137833806033','1','918780408353546240','1'),('918806410983137280','2022-01-02 11:39:01','2022-01-02 11:39:01',1,'lijialong','4200000013201710137859270000','1','918806410454654976','1'),('918833486129815552','2022-01-02 11:39:01','2022-01-02 11:39:01',1,'lijialong',NULL,'0','918833485639081984','1'),('918835712999055360','2022-01-02 11:39:01','2022-01-02 11:39:01',1,'lijialong','4200000018201710137883338612','1','918835712441212928','1');




