最新省市区县数据库

最新省市区县数据库 DROP TABLE IF EXISTS `area`; CREATE TABLE `area` ( `codeid` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `parentid` varchar(20) DEFAULT NULL, `name` varchar(100) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- ---------------------------- -- Records of area -- ---------------------------- INSERT INTO `area` VALUES ('11', '0', '北京'); INSERT INTO `area` VALUES ('1101', '11', '北京市辖'); ......