这个只有两级,想要详细的可以去下面这个网址,有的时候可能需要一点魔法
SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for kr_area -- ---------------------------- DROP TABLE IF EXISTS `kr_area`; CREATE TABLE `kr_area` ( `id` int(8) NOT NULL AUTO_INCREMENT, `area_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `vc_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `level` int(11) NULL DEFAULT NULL, `name_cn` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `name_en` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `name_kr` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `country` tinyint(1) NULL DEFAULT 1 COMMENT '1中国 0日本 2韩国', PRIMARY KEY (`id`, `area_code`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 293 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of kr_area -- ---------------------------- INSERT INTO `kr_area` VALUES (1, '82', 'AREA-82', 0, '韩国', NULL, '대한민국', 3); INSERT INTO `kr_area` VALUES (2, '8209', NULL, 1, '江原特别自治道', NULL, '강원특별자치도', 3); INSERT INTO `kr_area` VALUES (3, '8208', NULL, 1, '京畿道', NULL, '경기도', 3); INSERT INTO `kr_area` VALUES (4, '8215', NULL, 1, '庆尚南道', NULL, '경상남도', 3); INSERT INTO `kr_area` VALUES (5, '8214', NULL, 1, '庆尚北道', NULL, '경상북도', 3); INSERT INTO `kr_area` VALUES (6, '8205', NULL, 1, '光州广域市', NULL, '광주광역시', 3); INSERT INTO `kr_area` VALUES (7, '8203', NULL, 1, '大邱广域市', NULL, '대구광역시', 3); INSERT INTO `kr_area` VALUES (8, '8206', NULL, 1, '大田广域市', NULL, '대전광역시', 3); INSERT INTO `kr_area` VALUES (9, '8202', NULL, 1, '釜山广域市', NULL, '부산광역시', 3); INSERT INTO `kr_area` VALUES (10, '8201', NULL, 1, '首尔特别市', NULL, '서울특별시', 3); INSERT INTO `kr_area` VALUES (11, '8217', NULL, 1, '世宗特别自治市', NULL, '세종특별자치시', 3); INSERT INTO `kr_area` VALUES (12, '8207', NULL, 1, '蔚山广域市', NULL, '울산광역시', 3); INSERT INTO `kr_area` VALUES (13, '8204', NULL, 1, '仁川广域市', NULL, '인천광역시', 3); INSERT INTO `kr_area` VALUES (14, '8213', NULL, 1, '全罗南道', NULL, '전라남도', 3); INSERT INTO `kr_area` VALUES (15, '8212', NULL, 1, '全罗北道', NULL, '전라북도', 3); INSERT INTO `kr_area` VALUES (16, '8216', NULL, 1, '济州特别自治道', NULL, '제주특별자치도', 3); INSERT INTO `kr_area` VALUES (17, '8211', NULL, 1, '忠清南道', NULL, '충청남도', 3); INSERT INTO `kr_area` VALUES (18, '8210', NULL, 1, '忠清北道', NULL, '충청북도', 3); INSERT INTO `kr_area` VALUES (19, '820901', NULL, 2, NULL, NULL, '강릉시', 3); INSERT INTO `kr_area` VALUES (20, '820902', NULL, 2, NULL, NULL, '고성군', 3); INSERT INTO `kr_area` VALUES (21, '820903', NULL, 2, NULL, NULL, '동해시', 3); INSERT INTO `kr_area` VALUES (22, '820904', NULL, 2, NULL, NULL, '삼척시', 3); INSERT INTO `kr_area` VALUES (23, '820905', NULL, 2, NULL, NULL, '속초시', 3); INSERT INTO `kr_area` VALUES (24, '820906', NULL, 2, NULL, NULL, '양구군', 3); INSERT INTO `kr_area` VALUES (25, '820907', NULL, 2, NULL, NULL, '양양군', 3); INSERT INTO `kr_area` VALUES (26, '820908', NULL, 2, NULL, NULL, '영월군', 3); INSERT INTO `kr_area` VALUES (27, '820909', NULL, 2, NULL, NULL, '원주시', 3); INSERT INTO `kr_area` VALUES (28, '820910', NULL, 2, NULL, NULL, '인제군', 3); INSERT INTO `kr_area` VALUES (29, '820911', NULL, 2, NULL, NULL, '정선군', 3); INSERT INTO `kr_area` VALUES (30, '820912', NULL, 2, NULL, NULL, '철원군', 3); INSERT INTO `kr_area` VALUES (31, '820913', NULL, 2, NULL, NULL, '춘천시', 3); INSERT INTO `kr_area` VALUES (32, '820914', NULL, 2, NULL, NULL, '태백시', 3); INSERT INTO `kr_area` VALUES (33, '820915', NULL, 2, NULL, NULL, '평창군', 3); INSERT INTO `kr_area` VALUES (34, '820916', NULL, 2, NULL, NULL, '홍천군', 3); INSERT INTO `kr_area` VALUES (35, '820917', NULL, 2, NULL, NULL, '화천군', 3); INSERT INTO `kr_area` VALUES (36, '820918', NULL, 2, NULL, NULL, '횡성군', 3); INSERT INTO `kr_area` VALUES (37, '820801', NULL, 2, NULL, NULL, '가평군', 3); INSERT INTO `kr_area` VALUES (38, '820802', NULL, 2, NULL, NULL, '고양시', 3); INSERT INTO `kr_area` VALUES (39, '820803', NULL, 2, NULL, NULL, '고양시 덕양구', 3); INSERT INTO `kr_area` VALUES (40, '820804', NULL, 2, NULL, NULL, '고양시 일산동구', 3); INSERT INTO `kr_area` VALUES (41, '820805', NULL, 2, NULL, NULL, '고양시 일산서구', 3); INSERT INTO `kr_area` VALUES (42, '820806', NULL, 2, NULL, NULL, '과천시', 3); INSERT INTO `kr_area` VALUES (43, '820807', NULL, 2, NULL, NULL, '광명시', 3); INSERT INTO `kr_area` VALUES (44, '820808', NULL, 2, NULL, NULL, '광주시', 3); INSERT INTO `kr_area` VALUES (45, '820809', NULL, 2, NULL, NULL, '구리시', 3); INSERT INTO `kr_area` VALUES (46, '820810', NULL, 2, NULL, NULL, '군포시', 3); INSERT INTO `kr_area` VALUES (47, '820811', NULL, 2, NULL, NULL, '김포시', 3); INSERT INTO `kr_area` VALUES (48, '820812', NULL, 2, NULL, NULL, '남양주시', 3); INSERT INTO `kr_area` VALUES (49, '820813', NULL, 2, NULL, NULL, '동두천시', 3); INSERT INTO `kr_area` VALUES (50, '820814', NULL, 2, NULL, NULL, '부천시', 3); INSERT INTO `kr_area` VALUES (51, '820815', NULL, 2, NULL, NULL, '성남시 분당구', 3); INSERT INTO `kr_area` VALUES (52, '820816', NULL, 2, NULL, NULL, '성남시 수정구', 3); INSERT INTO `kr_area` VALUES (53, '820817', NULL, 2, NULL, NULL, '성남시 중원구', 3); INSERT INTO `kr_area` VALUES (54, '820818', NULL, 2, NULL, NULL, '수원시 권선구', 3); INSERT INTO `kr_area` VALUES (55, '820819', NULL, 2, NULL, NULL, '수원시 영통구', 3); INSERT INTO `kr_area` VALUES (56, '820820', NULL, 2, NULL, NULL, '수원시 장안구', 3); INSERT INTO `kr_area` VALUES (57, '820821', NULL, 2, NULL, NULL, '수원시 팔달구', 3); INSERT INTO `kr_area` VALUES (58, '820822', NULL, 2, NULL, NULL, '시흥시', 3); INSERT INTO `kr_area` VALUES (59, '820823', NULL, 2, NULL, NULL, '안산시 단원구', 3); INSERT INTO `kr_area` VALUES (60, '820824', NULL, 2, NULL, NULL, '안산시 상록구', 3); INSERT INTO `kr_area` VALUES (61, '820825', NULL, 2, NULL, NULL, '안성시', 3); INSERT INTO `kr_area` VALUES (62, '820826', NULL, 2, NULL, NULL, '안양시 동안구', 3); INSERT INTO `kr_area` VALUES (63, '820827', NULL, 2, NULL, NULL, '안양시 만안구', 3); INSERT INTO `kr_area` VALUES (64, '820828', NULL, 2, NULL, NULL, '양주시', 3); INSERT INTO `kr_area` VALUES (65, '820829', NULL, 2, NULL, NULL, '양평군', 3); INSERT INTO `kr_area` VALUES (66, '820830', NULL, 2, NULL, NULL, '여주시', 3); INSERT INTO `kr_area` VALUES (67, '820831', NULL, 2, NULL, NULL, '연천군', 3); INSERT INTO `kr_area` VALUES (68, '820832', NULL, 2, NULL, NULL, '오산시', 3); INSERT INTO `kr_area` VALUES (69, '820833', NULL, 2, NULL, NULL, '용인시 기흥구', 3); INSERT INTO `kr_area` VALUES (70, '820834', NULL, 2, NULL, NULL, '용인시 수지구', 3); INSERT INTO `kr_area` VALUES (71, '820835', NULL, 2, NULL, NULL, '용인시 처인구', 3); INSERT INTO `kr_area` VALUES (72, '820836', NULL, 2, NULL, NULL, '의왕시', 3); INSERT INTO `kr_area` VALUES (73, '820837', NULL, 2, NULL, NULL, '의정부시', 3); INSERT INTO `kr_area` VALUES (74, '820838', NULL, 2, NULL, NULL, '이천시', 3); INSERT INTO `kr_area` VALUES (75, '820839', NULL, 2, NULL, NULL, '파주시', 3); INSERT INTO `kr_area` VALUES (76, '820840', NULL, 2, NULL, NULL, '평택시', 3); INSERT INTO `kr_area` VALUES (77, '820841', NULL, 2, NULL, NULL, '포천시', 3); INSERT INTO `kr_area` VALUES (78, '820842', NULL, 2, NULL, NULL, '하남시', 3); INSERT INTO `kr_area` VALUES (79, '820843', NULL, 2, NULL, NULL, '화성시', 3); INSERT INTO `kr_area` VALUES (80, '821501', NULL, 2, NULL, NULL, '거제시', 3); INSERT INTO `kr_area` VALUES (81, '821502', NULL, 2, NULL, NULL, '거창군', 3); INSERT INTO `kr_area` VALUES (82, '821503', NULL, 2, NULL, NULL, '고성군', 3); INSERT INTO `kr_area` VALUES (83, '821504', NULL, 2, NULL, NULL, '김해시', 3); INSERT INTO `kr_area` VALUES (84, '821505', NULL, 2, NULL, NULL, '남해군', 3); INSERT INTO `kr_area` VALUES (85, '821506', NULL, 2, NULL, NULL, '밀양시', 3); INSERT INTO `kr_area` VALUES (86, '821507', NULL, 2, NULL, NULL, '사천시', 3); INSERT INTO `kr_area` VALUES (87, '821508', NULL, 2, NULL, NULL, '산청군', 3); INSERT INTO `kr_area` VALUES (88, '821509', NULL, 2, NULL, NULL, '양산시', 3); INSERT INTO `kr_area` VALUES (89, '821510', NULL, 2, NULL, NULL, '의령군', 3); INSERT INTO `kr_area` VALUES (90, '821511', NULL, 2, NULL, NULL, '진주시', 3); INSERT INTO `kr_area` VALUES (91, '821512', NULL, 2, NULL, NULL, '창녕군', 3); INSERT INTO `kr_area` VALUES (92, '821513', NULL, 2, NULL, NULL, '창원시 마산합포구', 3); INSERT INTO `kr_area` VALUES (93, '821514', NULL, 2, NULL, NULL, '창원시 마산회원구', 3); INSERT INTO `kr_area` VALUES (94, '821515', NULL, 2, NULL, NULL, '창원시 성산구', 3); INSERT INTO `kr_area` VALUES (95, '821516', NULL, 2, NULL, NULL, '창원시 의창구', 3); INSERT INTO `kr_area` VALUES (96, '821517', NULL, 2, NULL, NULL, '창원시 진해구', 3); INSERT INTO `kr_area` VALUES (97, '821518', NULL, 2, NULL, NULL, '통영시', 3); INSERT INTO `kr_area` VALUES (98, '821519', NULL, 2, NULL, NULL, '하동군', 3); INSERT INTO `kr_area` VALUES (99, '821520', NULL, 2, NULL, NULL, '함안군', 3); INSERT INTO `kr_area` VALUES (100, '821521', NULL, 2, NULL, NULL, '함양군', 3); INSERT INTO `kr_area` VALUES (101, '821522', NULL, 2, NULL, NULL, '합천군', 3); INSERT INTO `kr_area` VALUES (102, '821401', NULL, 2, NULL, NULL, '경산시', 3); INSERT INTO `kr_area` VALUES (103, '821402', NULL, 2, NULL, NULL, '경주시', 3); INSERT INTO `kr_area` VALUES (104, '821403', NULL, 2, NULL, NULL, '고령군', 3); INSERT INTO `kr_area` VALUES (105, '821404', NULL, 2, NULL, NULL, '구미시', 3); INSERT INTO `kr_area` VALUES (106, '821405', NULL, 2, NULL, NULL, '김천시', 3); INSERT INTO `kr_area` VALUES (107, '821406', NULL, 2, NULL, NULL, '문경시', 3); INSERT INTO `kr_area` VALUES (108, '821407', NULL, 2, NULL, NULL, '봉화군', 3); INSERT INTO `kr_area` VALUES (109, '821408', NULL, 2, NULL, NULL, '상주시', 3); INSERT INTO `kr_area` VALUES (110, '821409', NULL, 2, NULL, NULL, '성주군', 3); INSERT INTO `kr_area` VALUES (111, '821410', NULL, 2, NULL, NULL, '안동시', 3); INSERT INTO `kr_area` VALUES (112, '821411', NULL, 2, NULL, NULL, '영덕군', 3); INSERT INTO `kr_area` VALUES (113, '821412', NULL, 2, NULL, NULL, '영양군', 3); INSERT INTO `kr_area` VALUES (114, '821413', NULL, 2, NULL, NULL, '영주시', 3); INSERT INTO `kr_area` VALUES (115, '821414', NULL, 2, NULL, NULL, '영천시', 3); INSERT INTO `kr_area` VALUES (116, '821415', NULL, 2, NULL, NULL, '예천군', 3); INSERT INTO `kr_area` VALUES (117, '821416', NULL, 2, NULL, NULL, '울릉군', 3); INSERT INTO `kr_area` VALUES (118, '821417', NULL, 2, NULL, NULL, '울진군', 3); INSERT INTO `kr_area` VALUES (119, '821418', NULL, 2, NULL, NULL, '의성군', 3); INSERT INTO `kr_area` VALUES (120, '821419', NULL, 2, NULL, NULL, '청도군', 3); INSERT INTO `kr_area` VALUES (121, '821420', NULL, 2, NULL, NULL, '청송군', 3); INSERT INTO `kr_area` VALUES (122, '821421', NULL, 2, NULL, NULL, '칠곡군', 3); INSERT INTO `kr_area` VALUES (123, '821422', NULL, 2, NULL, NULL, '포항시', 3); INSERT INTO `kr_area` VALUES (124, '821423', NULL, 2, NULL, NULL, '포항시 남구', 3); INSERT INTO `kr_area` VALUES (125, '821424', NULL, 2, NULL, NULL, '포항시 북구', 3); INSERT INTO `kr_area` VALUES (126, '820501', NULL, 2, NULL, NULL, '광산구', 3); INSERT INTO `kr_area` VALUES (127, '820502', NULL, 2, NULL, NULL, '남구', 3); INSERT INTO `kr_area` VALUES (128, '820503', NULL, 2, NULL, NULL, '동구', 3); INSERT INTO `kr_area` VALUES (129, '820504', NULL, 2, NULL, NULL, '북구', 3); INSERT INTO `kr_area` VALUES (130, '820505', NULL, 2, NULL, NULL, '서구', 3); INSERT INTO `kr_area` VALUES (131, '820301', NULL, 2, NULL, NULL, '군위군', 3); INSERT INTO `kr_area` VALUES (132, '820302', NULL, 2, NULL, NULL, '남구', 3); INSERT INTO `kr_area` VALUES (133, '820303', NULL, 2, NULL, NULL, '달서구', 3); INSERT INTO `kr_area` VALUES (134, '820304', NULL, 2, NULL, NULL, '달성군', 3); INSERT INTO `kr_area` VALUES (135, '820305', NULL, 2, NULL, NULL, '동구', 3); INSERT INTO `kr_area` VALUES (136, '820306', NULL, 2, NULL, NULL, '북구', 3); INSERT INTO `kr_area` VALUES (137, '820307', NULL, 2, NULL, NULL, '서구', 3); INSERT INTO `kr_area` VALUES (138, '820308', NULL, 2, NULL, NULL, '수성구', 3); INSERT INTO `kr_area` VALUES (139, '820309', NULL, 2, NULL, NULL, '중구', 3); INSERT INTO `kr_area` VALUES (140, '820601', NULL, 2, NULL, NULL, '대덕구', 3); INSERT INTO `kr_area` VALUES (141, '820602', NULL, 2, NULL, NULL, '동구', 3); INSERT INTO `kr_area` VALUES (142, '820603', NULL, 2, NULL, NULL, '서구', 3); INSERT INTO `kr_area` VALUES (143, '820604', NULL, 2, NULL, NULL, '유성구', 3); INSERT INTO `kr_area` VALUES (144, '820605', NULL, 2, NULL, NULL, '중구', 3); INSERT INTO `kr_area` VALUES (145, '820201', NULL, 2, NULL, NULL, '강서구', 3); INSERT INTO `kr_area` VALUES (146, '820202', NULL, 2, NULL, NULL, '금정구', 3); INSERT INTO `kr_area` VALUES (147, '820203', NULL, 2, NULL, NULL, '기장군', 3); INSERT INTO `kr_area` VALUES (148, '820204', NULL, 2, NULL, NULL, '남구', 3); INSERT INTO `kr_area` VALUES (149, '820205', NULL, 2, NULL, NULL, '동구', 3); INSERT INTO `kr_area` VALUES (150, '820206', NULL, 2, NULL, NULL, '동래구', 3); INSERT INTO `kr_area` VALUES (151, '820207', NULL, 2, NULL, NULL, '부산진구', 3); INSERT INTO `kr_area` VALUES (152, '820208', NULL, 2, NULL, NULL, '북구', 3); INSERT INTO `kr_area` VALUES (153, '820209', NULL, 2, NULL, NULL, '사상구', 3); INSERT INTO `kr_area` VALUES (154, '820210', NULL, 2, NULL, NULL, '사하구', 3); INSERT INTO `kr_area` VALUES (155, '820211', NULL, 2, NULL, NULL, '서구', 3); INSERT INTO `kr_area` VALUES (156, '820212', NULL, 2, NULL, NULL, '수영구', 3); INSERT INTO `kr_area` VALUES (157, '820213', NULL, 2, NULL, NULL, '연제구', 3); INSERT INTO `kr_area` VALUES (158, '820214', NULL, 2, NULL, NULL, '영도구', 3); INSERT INTO `kr_area` VALUES (159, '820215', NULL, 2, NULL, NULL, '중구', 3); INSERT INTO `kr_area` VALUES (160, '820216', NULL, 2, NULL, NULL, '해운대구', 3); INSERT INTO `kr_area` VALUES (161, '820101', NULL, 2, NULL, NULL, '강남구', 3); INSERT INTO `kr_area` VALUES (162, '820102', NULL, 2, NULL, NULL, '강동구', 3); INSERT INTO `kr_area` VALUES (163, '820103', NULL, 2, NULL, NULL, '강북구', 3); INSERT INTO `kr_area` VALUES (164, '820104', NULL, 2, NULL, NULL, '강서구', 3); INSERT INTO `kr_area` VALUES (165, '820105', NULL, 2, NULL, NULL, '관악구', 3); INSERT INTO `kr_area` VALUES (166, '820106', NULL, 2, NULL, NULL, '광진구', 3); INSERT INTO `kr_area` VALUES (167, '820107', NULL, 2, NULL, NULL, '구로구', 3); INSERT INTO `kr_area` VALUES (168, '820108', NULL, 2, NULL, NULL, '금천구', 3); INSERT INTO `kr_area` VALUES (169, '820109', NULL, 2, NULL, NULL, '노원구', 3); INSERT INTO `kr_area` VALUES (170, '820110', NULL, 2, NULL, NULL, '도봉구', 3); INSERT INTO `kr_area` VALUES (171, '820111', NULL, 2, NULL, NULL, '동대문구', 3); INSERT INTO `kr_area` VALUES (172, '820112', NULL, 2, NULL, NULL, '동작구', 3); INSERT INTO `kr_area` VALUES (173, '820113', NULL, 2, NULL, NULL, '마포구', 3); INSERT INTO `kr_area` VALUES (174, '820114', NULL, 2, NULL, NULL, '서대문구', 3); INSERT INTO `kr_area` VALUES (175, '820115', NULL, 2, NULL, NULL, '서초구', 3); INSERT INTO `kr_area` VALUES (176, '820116', NULL, 2, NULL, NULL, '성동구', 3); INSERT INTO `kr_area` VALUES (177, '820117', NULL, 2, NULL, NULL, '성북구', 3); INSERT INTO `kr_area` VALUES (178, '820118', NULL, 2, NULL, NULL, '송파구', 3); INSERT INTO `kr_area` VALUES (179, '820119', NULL, 2, NULL, NULL, '양천구', 3); INSERT INTO `kr_area` VALUES (180, '820120', NULL, 2, NULL, NULL, '영등포구', 3); INSERT INTO `kr_area` VALUES (181, '820121', NULL, 2, NULL, NULL, '용산구', 3); INSERT INTO `kr_area` VALUES (182, '820122', NULL, 2, NULL, NULL, '은평구', 3); INSERT INTO `kr_area` VALUES (183, '820123', NULL, 2, NULL, NULL, '종로구', 3); INSERT INTO `kr_area` VALUES (184, '820124', NULL, 2, NULL, NULL, '중구', 3); INSERT INTO `kr_area` VALUES (185, '820125', NULL, 2, NULL, NULL, '중랑구', 3); INSERT INTO `kr_area` VALUES (186, '820701', NULL, 2, NULL, NULL, '남구', 3); INSERT INTO `kr_area` VALUES (187, '820702', NULL, 2, NULL, NULL, '동구', 3); INSERT INTO `kr_area` VALUES (188, '820703', NULL, 2, NULL, NULL, '북구', 3); INSERT INTO `kr_area` VALUES (189, '820704', NULL, 2, NULL, NULL, '울주군', 3); INSERT INTO `kr_area` VALUES (190, '820705', NULL, 2, NULL, NULL, '중구', 3); INSERT INTO `kr_area` VALUES (191, '820401', NULL, 2, NULL, NULL, '강화군', 3); INSERT INTO `kr_area` VALUES (192, '820402', NULL, 2, NULL, NULL, '계양구', 3); INSERT INTO `kr_area` VALUES (193, '820403', NULL, 2, NULL, NULL, '남동구', 3); INSERT INTO `kr_area` VALUES (194, '820404', NULL, 2, NULL, NULL, '동구', 3); INSERT INTO `kr_area` VALUES (195, '820405', NULL, 2, NULL, NULL, '미추홀구', 3); INSERT INTO `kr_area` VALUES (196, '820406', NULL, 2, NULL, NULL, '부평구', 3); INSERT INTO `kr_area` VALUES (197, '820407', NULL, 2, NULL, NULL, '서구', 3); INSERT INTO `kr_area` VALUES (198, '820408', NULL, 2, NULL, NULL, '연수구', 3); INSERT INTO `kr_area` VALUES (199, '820409', NULL, 2, NULL, NULL, '옹진군', 3); INSERT INTO `kr_area` VALUES (200, '820410', NULL, 2, NULL, NULL, '중구', 3); INSERT INTO `kr_area` VALUES (201, '821301', NULL, 2, NULL, NULL, '강진군', 3); INSERT INTO `kr_area` VALUES (202, '821302', NULL, 2, NULL, NULL, '고흥군', 3); INSERT INTO `kr_area` VALUES (203, '821303', NULL, 2, NULL, NULL, '곡성군', 3); INSERT INTO `kr_area` VALUES (204, '821304', NULL, 2, NULL, NULL, '광양시', 3); INSERT INTO `kr_area` VALUES (205, '821305', NULL, 2, NULL, NULL, '구례군', 3); INSERT INTO `kr_area` VALUES (206, '821306', NULL, 2, NULL, NULL, '나주시', 3); INSERT INTO `kr_area` VALUES (207, '821307', NULL, 2, NULL, NULL, '담?映?2', 3); INSERT INTO `kr_area` VALUES (208, '821308', NULL, 2, NULL, NULL, '담양군', 3); INSERT INTO `kr_area` VALUES (209, '821309', NULL, 2, NULL, NULL, '목포시', 3); INSERT INTO `kr_area` VALUES (210, '821310', NULL, 2, NULL, NULL, '무안군', 3); INSERT INTO `kr_area` VALUES (211, '821311', NULL, 2, NULL, NULL, '보성군', 3); INSERT INTO `kr_area` VALUES (212, '821312', NULL, 2, NULL, NULL, '순천시', 3); INSERT INTO `kr_area` VALUES (213, '821313', NULL, 2, NULL, NULL, '신안군', 3); INSERT INTO `kr_area` VALUES (214, '821314', NULL, 2, NULL, NULL, '여수시', 3); INSERT INTO `kr_area` VALUES (215, '821315', NULL, 2, NULL, NULL, '영광군', 3); INSERT INTO `kr_area` VALUES (216, '821316', NULL, 2, NULL, NULL, '영암군', 3); INSERT INTO `kr_area` VALUES (217, '821317', NULL, 2, NULL, NULL, '완도군', 3); INSERT INTO `kr_area` VALUES (218, '821318', NULL, 2, NULL, NULL, '장성군', 3); INSERT INTO `kr_area` VALUES (219, '821319', NULL, 2, NULL, NULL, '장흥군', 3); INSERT INTO `kr_area` VALUES (220, '821320', NULL, 2, NULL, NULL, '진도군', 3); INSERT INTO `kr_area` VALUES (221, '821321', NULL, 2, NULL, NULL, '함평군', 3); INSERT INTO `kr_area` VALUES (222, '821322', NULL, 2, NULL, NULL, '해남군', 3); INSERT INTO `kr_area` VALUES (223, '821323', NULL, 2, NULL, NULL, '화순군', 3); INSERT INTO `kr_area` VALUES (224, '821201', NULL, 2, NULL, NULL, '고창군', 3); INSERT INTO `kr_area` VALUES (225, '821202', NULL, 2, NULL, NULL, '군산시', 3); INSERT INTO `kr_area` VALUES (226, '821203', NULL, 2, NULL, NULL, '김제시', 3); INSERT INTO `kr_area` VALUES (227, '821204', NULL, 2, NULL, NULL, '남원시', 3); INSERT INTO `kr_area` VALUES (228, '821205', NULL, 2, NULL, NULL, '무주군', 3); INSERT INTO `kr_area` VALUES (229, '821206', NULL, 2, NULL, NULL, '부안군', 3); INSERT INTO `kr_area` VALUES (230, '821207', NULL, 2, NULL, NULL, '순창군', 3); INSERT INTO `kr_area` VALUES (231, '821208', NULL, 2, NULL, NULL, '완주군', 3); INSERT INTO `kr_area` VALUES (232, '821209', NULL, 2, NULL, NULL, '익산시', 3); INSERT INTO `kr_area` VALUES (233, '821210', NULL, 2, NULL, NULL, '임실군', 3); INSERT INTO `kr_area` VALUES (234, '821211', NULL, 2, NULL, NULL, '장수군', 3); INSERT INTO `kr_area` VALUES (235, '821212', NULL, 2, NULL, NULL, '전주시 덕진구', 3); INSERT INTO `kr_area` VALUES (236, '821213', NULL, 2, NULL, NULL, '전주시 완산구', 3); INSERT INTO `kr_area` VALUES (237, '821214', NULL, 2, NULL, NULL, '정읍시', 3); INSERT INTO `kr_area` VALUES (238, '821215', NULL, 2, NULL, NULL, '진안군', 3); INSERT INTO `kr_area` VALUES (239, '821601', NULL, 2, NULL, NULL, '서귀포시', 3); INSERT INTO `kr_area` VALUES (240, '821602', NULL, 2, NULL, NULL, '제주시', 3); INSERT INTO `kr_area` VALUES (241, '821101', NULL, 2, NULL, NULL, '계룡시', 3); INSERT INTO `kr_area` VALUES (242, '821102', NULL, 2, NULL, NULL, '공주시', 3); INSERT INTO `kr_area` VALUES (243, '821103', NULL, 2, NULL, NULL, '금산군', 3); INSERT INTO `kr_area` VALUES (244, '821104', NULL, 2, NULL, NULL, '논산시', 3); INSERT INTO `kr_area` VALUES (245, '821105', NULL, 2, NULL, NULL, '당진시', 3); INSERT INTO `kr_area` VALUES (246, '821106', NULL, 2, NULL, NULL, '보령시', 3); INSERT INTO `kr_area` VALUES (247, '821107', NULL, 2, NULL, NULL, '부여군', 3); INSERT INTO `kr_area` VALUES (248, '821108', NULL, 2, NULL, NULL, '서산시', 3); INSERT INTO `kr_area` VALUES (249, '821109', NULL, 2, NULL, NULL, '서천군', 3); INSERT INTO `kr_area` VALUES (250, '821110', NULL, 2, NULL, NULL, '아산시', 3); INSERT INTO `kr_area` VALUES (251, '821111', NULL, 2, NULL, NULL, '예산군', 3); INSERT INTO `kr_area` VALUES (252, '821112', NULL, 2, NULL, NULL, '천안시 동남구', 3); INSERT INTO `kr_area` VALUES (253, '821113', NULL, 2, NULL, NULL, '천안시 서북구', 3); INSERT INTO `kr_area` VALUES (254, '821114', NULL, 2, NULL, NULL, '청양군', 3); INSERT INTO `kr_area` VALUES (255, '821115', NULL, 2, NULL, NULL, '태안군', 3); INSERT INTO `kr_area` VALUES (256, '821116', NULL, 2, NULL, NULL, '홍성군', 3); INSERT INTO `kr_area` VALUES (257, '821001', NULL, 2, NULL, NULL, '괴산군', 3); INSERT INTO `kr_area` VALUES (258, '821002', NULL, 2, NULL, NULL, '단양군', 3); INSERT INTO `kr_area` VALUES (259, '821003', NULL, 2, NULL, NULL, '보은군', 3); INSERT INTO `kr_area` VALUES (260, '821004', NULL, 2, NULL, NULL, '영동군', 3); INSERT INTO `kr_area` VALUES (261, '821005', NULL, 2, NULL, NULL, '옥천군', 3); INSERT INTO `kr_area` VALUES (262, '821006', NULL, 2, NULL, NULL, '음성군', 3); INSERT INTO `kr_area` VALUES (263, '821007', NULL, 2, NULL, NULL, '제천시', 3); INSERT INTO `kr_area` VALUES (264, '821008', NULL, 2, NULL, NULL, '증평군', 3); INSERT INTO `kr_area` VALUES (265, '821009', NULL, 2, NULL, NULL, '진천군', 3); INSERT INTO `kr_area` VALUES (266, '821010', NULL, 2, NULL, NULL, '청주시 상당구', 3); INSERT INTO `kr_area` VALUES (267, '821011', NULL, 2, NULL, NULL, '청주시 서원구', 3); INSERT INTO `kr_area` VALUES (268, '821012', NULL, 2, NULL, NULL, '청주시 청원구', 3); INSERT INTO `kr_area` VALUES (269, '821013', NULL, 2, NULL, NULL, '청주시 흥덕구', 3); INSERT INTO `kr_area` VALUES (270, '821014', NULL, 2, NULL, NULL, '충주시', 3); INSERT INTO `kr_area` VALUES (271, '821701', NULL, 2, '鸟致院邑', NULL, '조치원읍', 3); INSERT INTO `kr_area` VALUES (272, '821702', NULL, 2, '燕岐面', NULL, '연기면', 3); INSERT INTO `kr_area` VALUES (273, '821703', NULL, 2, '燕东面', NULL, '연동면', 3); INSERT INTO `kr_area` VALUES (274, '821704', NULL, 2, '芙江面', NULL, '부강면', 3); INSERT INTO `kr_area` VALUES (275, '821705', NULL, 2, '锦南面', NULL, '금남면', 3); INSERT INTO `kr_area` VALUES (276, '821706', NULL, 2, '将军面', NULL, '장군면', 3); INSERT INTO `kr_area` VALUES (277, '821707', NULL, 2, '燕西面', NULL, '연서면', 3); INSERT INTO `kr_area` VALUES (278, '821708', NULL, 2, '全义面', NULL, '전의면', 3); INSERT INTO `kr_area` VALUES (279, '821709', NULL, 2, '全东面', NULL, '전동면', 3); INSERT INTO `kr_area` VALUES (280, '821710', NULL, 2, '小井面', NULL, '소정면', 3); INSERT INTO `kr_area` VALUES (281, '821711', NULL, 2, '松树洞', NULL, '한솔동', 3); INSERT INTO `kr_area` VALUES (282, '821712', NULL, 2, '新洞', NULL, '새롬동', 3); INSERT INTO `kr_area` VALUES (283, '821713', NULL, 2, '和睦洞', NULL, '다정동', 3); INSERT INTO `kr_area` VALUES (284, '821714', NULL, 2, '精明洞', NULL, '도담동', 3); INSERT INTO `kr_area` VALUES (285, '821715', NULL, 2, '海密洞', NULL, '해밀동', 3); INSERT INTO `kr_area` VALUES (286, '821716', NULL, 2, '美丽洞', NULL, '아름동', 3); INSERT INTO `kr_area` VALUES (287, '821717', NULL, 2, '宗村洞', NULL, '종촌동', 3); INSERT INTO `kr_area` VALUES (288, '821718', NULL, 2, '高云洞', NULL, '고운동', 3); INSERT INTO `kr_area` VALUES (289, '821719', NULL, 2, '成就洞', NULL, '보람동', 3); INSERT INTO `kr_area` VALUES (290, '821720', NULL, 2, '大坪洞', NULL, '대평동', 3); INSERT INTO `kr_area` VALUES (291, '821721', NULL, 2, '富饶洞', NULL, '소담동', 3); INSERT INTO `kr_area` VALUES (292, '821722', NULL, 2, '盘谷洞', NULL, '반곡동', 3); SET FOREIGN_KEY_CHECKS = 1;
0条评论
点击登录参与评论