文件名称：locations.sql
文件大小：334KB
文件格式：SQL
更新时间：2023-07-29 03:26:05
有level三级分类省市县
很全，值得拥有 CREATE TABLE `locations` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `parent_id` int(10) unsigned NOT NULL, `level` tinyint(4) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5025 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- ---------------------------- -- Records of locations -- ---------------------------- INSERT INTO `locations` VALUES ('1', '北京市', '0', '1'); INSERT INTO `locations` VALUES ('2', '天津市', '0', '1'); INSERT INTO `locations` VALUES ('3', '河北省', '0', '1'); INSERT INTO `locations` VALUES ('4', '山西省', '0', '1'); INSERT INTO `locations` VALUES ('5', '内蒙古自治区', '0', '1'); INSERT INTO `locations` VALUES ('6', '辽宁省', '0', '1'); INSERT INTO `locations` VALUES ('7', '吉林省', '0', '1'); INSERT INTO `locations` VALUES ('8', '黑龙江省', '0', '1'); INSERT INTO `locations` VALUES ('9', '上海市', '0', '1'); INSERT INTO `locations` VALUES ('10', '江苏省', '0', '1'); INSERT INTO `locations` VALUES ('11', '浙江省', '0', '1'); INSERT INTO `locations` VALUES ('12', '安徽省', '0', '1'); INSERT INTO `locations` VALUES ('13', '福建省', '0', '1'); INSERT INTO `locations` VALUES ('14', '江西省', '0', '1');