本文由 资源共享网 – zygxw 发布，转载请注明出处，如有问题请联系我们！五级区域城乡划分mysql数据（到县级）

DROP TABLE IF EXISTS `region`;

CREATE TABLE `region` (

  `code` varchar(255) DEFAULT NULL COMMENT '区域code',  

  `name` varchar(255) DEFAULT NULL COMMENT '区域名称',

  `pcode` varchar(255) DEFAULT NULL COMMENT '父code',

  `href` varchar(255) DEFAULT NULL COMMENT '页面url',

  `grade` int(11) DEFAULT NULL COMMENT '区域等级'

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `region` VALUES ('610100000000', '西安市', '610000000000', '61/6101.html', '2');

INSERT INTO `region` VALUES ('610200000000', '铜川市', '610000000000', '61/6102.html', '2');

INSERT INTO `region` VALUES ('610300000000', '宝鸡市', '610000000000', '61/6103.html', '2');

INSERT INTO `region` VALUES ('610400000000', '咸阳市', '610000000000', '61/6104.html', '2');

INSERT INTO `region` VALUES ('610500000000', '渭南市', '610000000000', '61/6105.html', '2');

INSERT INTO `region` VALUES ('610600000000', '延安市', '610000000000', '61/6106.html', '2');

INSERT INTO `region` VALUES ('610700000000', '汉中市', '610000000000', '61/6107.html', '2');

INSERT INTO `region` VALUES ('610800000000', '榆林市', '610000000000', '61/6108.html', '2');

INSERT INTO `region` VALUES ('610900000000', '安康市', '610000000000', '61/6109.html', '2');

INSERT INTO `region` VALUES ('611000000000', '商洛市', '610000000000', '61/6110.html', '2');

INSERT INTO `region` VALUES ('620100000000', '兰州市', '620000000000', '62/6201.html', '2');

INSERT INTO `region` VALUES ('620200000000', '嘉峪关市', '620000000000', '62/6202.html', '2');