全球机场数据mysql(包含全国机场数据,国外大中小机场数据)

最近整理了一个全球机场数据mysql版,挺全的

包含全国全球各大机场数据(所属城市     三字代码     国家     国家代码     四字代码     机场名称     英文)

全国全球机场数据由三个表组成lk_airport(机场名称数据表)、lk_airport_city(国内城市表)、lk_airport_inter_city(国外城市表)组成

城市表数据是参考携程的,机场名称数据是http://www.hlhkys.com/dmair/cx.asp这边采集的

直接上mysql语句

/*
Date: 2015-11-27 17:24:30
*/
SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for lk_airport
-- ----------------------------
DROP TABLE IF EXISTS `lk_airport`;
CREATE TABLE `lk_airport` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '机场名',
  `city_id` int(10) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '1正常 0删除',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1397 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of lk_airport
-- ----------------------------
INSERT INTO `lk_airport` VALUES ('1', '首都机场', '17', '0');
INSERT INTO `lk_airport` VALUES ('2', '宝安机场', '146', '0');
INSERT INTO `lk_airport` VALUES ('3', '凤凰国际机场', '145', '0');
INSERT INTO `lk_airport` VALUES ('4', '仁川国际机场', '301', '0');
INSERT INTO `lk_airport` VALUES ('5', '白云机场', '399', '0');
INSERT INTO `lk_airport` VALUES ('6', '白云机场', '54', '0');
INSERT INTO `lk_airport` VALUES ('7', '安康富强机场', '2', '0');
INSERT INTO `lk_airport` VALUES ('8', '阿里昆莎机场', '8', '0');
INSERT INTO `lk_airport` VALUES ('9', 'AAA机场', '351', '0');
INSERT INTO `lk_airport` VALUES ('10', 'BBB机场', '142', '0');
INSERT INTO `lk_airport` VALUES ('11', '北京首都国际机场T3', '17', '0');
INSERT INTO `lk_airport` VALUES ('1001', '洛杉矶机场', '358', '1');
INSERT INTO `lk_airport` VALUES ('1002', '伦敦希思罗机场', '327', '1');
INSERT INTO `lk_airport` VALUES ('1003', '肯尼迪机场', '357', '1');
INSERT INTO `lk_airport` VALUES ('1004', '法兰克福机场', '329', '1');
INSERT INTO `lk_airport` VALUES ('1005', '上海虹桥机场', '141', '1');
INSERT INTO `lk_airport` VALUES ('1006', '迪拜机场', '314', '1');
INSERT INTO `lk_airport` VALUES ('1007', '戴高乐机场', '328', '1');
INSERT INTO `lk_airport` VALUES ('1008', '广州白云机场', '54', '1');
INSERT INTO `lk_airport` VALUES ('1009', '北京首都机场', '17', '1');
INSERT INTO `lk_airport` VALUES ('1010', '樟宜机场', '302', '1');
INSERT INTO `lk_airport` VALUES ('1011', '悉尼', '412', '1');
INSERT INTO `lk_airport` VALUES ('1012', '谢诺梅杰沃机场', '330', '1');
INSERT INTO `lk_airport` VALUES ('1013', '多伦多', '362', '1');
INSERT INTO `lk_airport` VALUES ('1014', '深圳宝安机场', '146', '1');
INSERT INTO `lk_airport` VALUES ('1015', '布达佩斯机场', '353', '1');
INSERT INTO `lk_airport` VALUES ('1016', '墨西哥城机场', '377', '1');
INSERT INTO `lk_airport` VALUES ('1017', '温哥华', '360', '1');
INSERT INTO `lk_airport` VALUES ('1018', '爱华隆机场', '413', '1');
INSERT INTO `lk_airport` VALUES ('1019', '汉堡机场', '354', '1');
INSERT INTO `lk_airport` VALUES ('1020', '孟买机场', '325', '1');
INSERT INTO `lk_airport` VALUES ('1021', '阿塔图尔克机场', '323', '1');
INSERT INTO `lk_airport` VALUES ('1022', '米兰马尔本萨机场', '333', '1');
INSERT INTO `lk_airport` VALUES ('1023', '芝加哥机场', '361', '1');
INSERT INTO `lk_airport` VALUES ('1024', '荷兰阿姆斯特丹斯史基浦(西霍普)机场', '332', '1');
INSERT INTO `lk_airport` VALUES ('1025', '香港赤鱲角国际机场', '209', '1');
INSERT INTO `lk_airport` VALUES ('1026', '曼谷(素万那普)机场', '303', '1');
INSERT INTO `lk_airport` VALUES ('1027', '东京机场', '300', '1');
INSERT INTO `lk_airport` VALUES ('1028', '圣保罗机场', '375', '1');
INSERT INTO `lk_airport` VALUES ('1029', '成都双流机场', '30', '1');
INSERT INTO `lk_airport` VALUES ('1030', '开罗机场', '387', '1');
INSERT INTO `lk_airport` VALUES ('1031', '吉隆坡机场', '304', '1');
INSERT INTO `lk_airport` VALUES ('1032', '拉各斯机场', '391', '1');
INSERT INTO `lk_airport` VALUES ('1033', '约翰内斯堡机场', '388', '1');
INSERT INTO `lk_airport` VALUES ('1034', '乌鲁木齐地窝堡机场', '161', '1');
INSERT INTO `lk_airport` VALUES ('1035', '重庆江北机场', '27', '1');
INSERT INTO `lk_airport` VALUES ('1036', '迈阿密机场', '380', '1');
INSERT INTO `lk_airport` VALUES ('1037', '蒙特利尔', '369', '1');
INSERT INTO `lk_airport` VALUES ('1038', '雅加达 苏加诺-哈达机场', '306', '1');
INSERT INTO `lk_airport` VALUES ('1039', '旧金山机场', '359', '1');
INSERT INTO `lk_airport` VALUES ('1040', '布鲁塞尔机场', '340', '1');
INSERT INTO `lk_airport` VALUES ('1041', '卢萨卡机场', '402', '1');
INSERT INTO `lk_airport` VALUES ('1042', '台北松山机场', '211', '1');
INSERT INTO `lk_airport` VALUES ('1043', '胡志明市机场', '307', '1');
INSERT INTO `lk_airport` VALUES ('1044', '基辅机场', '352', '1');
INSERT INTO `lk_airport` VALUES ('1045', '马德里机场', '338', '1');
INSERT INTO `lk_airport` VALUES ('1046', '马尼拉机场', '308', '1');
INSERT INTO `lk_airport` VALUES ('1047', '奥克兰机场', '414', '1');
INSERT INTO `lk_airport` VALUES ('1048', '曼彻斯特机场', '337', '1');
INSERT INTO `lk_airport` VALUES ('1049', '上海浦东机场', '141', '1');
INSERT INTO `lk_airport` VALUES ('1050', '布宜诺斯艾利斯机场', '386', '1');
INSERT INTO `lk_airport` VALUES ('1051', '昆明巫家坝机场', '98', '1');
INSERT INTO `lk_airport` VALUES ('1052', '菲乌米奇诺机场', '331', '1');
INSERT INTO `lk_airport` VALUES ('1053', '巴塞罗那机场', '344', '1');
INSERT INTO `lk_airport` VALUES ('1054', '哥本哈根机场', '341', '1');
INSERT INTO `lk_airport` VALUES ('1055', '赫尔辛基机场', '342', '1');
INSERT INTO `lk_airport` VALUES ('1056', '达拉斯沃尔斯堡机场', '372', '1');
INSERT INTO `lk_airport` VALUES ('1057', '西雅图机场', '363', '1');
INSERT INTO `lk_airport` VALUES ('1058', '加德满都机场', '316', '1');
INSERT INTO `lk_airport` VALUES ('1059', '河内机场', '312', '1');
INSERT INTO `lk_airport` VALUES ('1060', '首尔仁川机场', '301', '1');
INSERT INTO `lk_airport` VALUES ('1061', '布拉格机场', '355', '1');
INSERT INTO `lk_airport` VALUES ('1062', '青岛流亭机场', '138', '1');
INSERT INTO `lk_airport` VALUES ('1063', '布里斯班机场', '415', '1');
INSERT INTO `lk_airport` VALUES ('1064', '关西机场', '305', '1');
INSERT INTO `lk_airport` VALUES ('1065', '斯德哥尔摩机场', '335', '1');
INSERT INTO `lk_airport` VALUES ('1066', '武汉天河机场', '167', '1');
INSERT INTO `lk_airport` VALUES ('1067', '底特律机场', '366', '1');
INSERT INTO `lk_airport` VALUES ('1068', '哈尔滨太平机场', '75', '1');
INSERT INTO `lk_airport` VALUES ('1069', '沈阳桃仙机场', '142', '1');
INSERT INTO `lk_airport` VALUES ('1070', '大连国际机场', '39', '1');
INSERT INTO `lk_airport` VALUES ('1071', '波士顿机场', '365', '1');
INSERT INTO `lk_airport` VALUES ('1072', '华盛顿机场', '364', '1');
INSERT INTO `lk_airport` VALUES ('1073', '日内瓦机场', '349', '1');
INSERT INTO `lk_airport` VALUES ('1074', '苏黎世机场', '339', '1');
INSERT INTO `lk_airport` VALUES ('1075', '亚特兰大机场', '367', '1');
INSERT INTO `lk_airport` VALUES ('1076', '伯明翰机场', '347', '1');
INSERT INTO `lk_airport` VALUES ('1077', '雅典机场', '345', '1');
INSERT INTO `lk_airport` VALUES ('1078', '西安咸阳机场', '178', '1');
INSERT INTO `lk_airport` VALUES ('1079', '天津滨海机场', '157', '1');
INSERT INTO `lk_airport` VALUES ('1080', '杭州萧山机场', '70', '1');
INSERT INTO `lk_airport` VALUES ('1081', '默罕默德V机场', '399', '1');
INSERT INTO `lk_airport` VALUES ('1082', '慕尼黑机场', '334', '1');
INSERT INTO `lk_airport` VALUES ('1083', '圣彼得堡机场', '350', '1');
INSERT INTO `lk_airport` VALUES ('1084', '维也纳机场', '343', '1');
INSERT INTO `lk_airport` VALUES ('1085', '泰格尔机场', '336', '1');
INSERT INTO `lk_airport` VALUES ('1086', '珀斯机场', '417', '1');
INSERT INTO `lk_airport` VALUES ('1087', '长沙黄花机场', '29', '1');
INSERT INTO `lk_airport` VALUES ('1088', '科托卡机场', '397', '1');
INSERT INTO `lk_airport` VALUES ('1089', '郑州新郑机场', '198', '1');
INSERT INTO `lk_airport` VALUES ('1090', '开普顿机场', '389', '1');
INSERT INTO `lk_airport` VALUES ('1091', '济南遥墙机场', '92', '1');
INSERT INTO `lk_airport` VALUES ('1092', '罗安达二月四日机场', '392', '1');
INSERT INTO `lk_airport` VALUES ('1093', '厦门高崎机场', '179', '1');
INSERT INTO `lk_airport` VALUES ('1094', '丹佛机场', '381', '1');
INSERT INTO `lk_airport` VALUES ('1095', '杜塞尔多夫机场', '356', '1');
INSERT INTO `lk_airport` VALUES ('1096', '阿尔及尔机场', '398', '1');
INSERT INTO `lk_airport` VALUES ('1097', '贵阳龙洞堡机场', '60', '1');
INSERT INTO `lk_airport` VALUES ('1098', '海口美兰机场', '64', '1');
INSERT INTO `lk_airport` VALUES ('1099', '长春龙嘉国际机场', '23', '1');
INSERT INTO `lk_airport` VALUES ('1100', '德班机场', '400', '1');
INSERT INTO `lk_airport` VALUES ('1101', '南京禄口机场', '125', '1');
INSERT INTO `lk_airport` VALUES ('1102', '温州永强机场', '165', '1');
INSERT INTO `lk_airport` VALUES ('1103', '喀土穆机场', '396', '1');
INSERT INTO `lk_airport` VALUES ('1104', '拉斯维加斯麦卡伦国际机场机场', '378', '1');
INSERT INTO `lk_airport` VALUES ('1105', '金边机场', '319', '1');
INSERT INTO `lk_airport` VALUES ('1106', '宁波栎社机场', '124', '1');
INSERT INTO `lk_airport` VALUES ('1107', '哈拉雷机场', '403', '1');
INSERT INTO `lk_airport` VALUES ('1108', '马累机场', '313', '1');
INSERT INTO `lk_airport` VALUES ('1109', '南昌昌北机场', '122', '1');
INSERT INTO `lk_airport` VALUES ('1110', '波特兰机场', '383', '1');
INSERT INTO `lk_airport` VALUES ('1111', '亚的斯亚贝巴机场', '395', '1');
INSERT INTO `lk_airport` VALUES ('1112', '格拉斯哥机场', '351', '1');
INSERT INTO `lk_airport` VALUES ('1113', '名古屋中部/新特丽亚机场', '310', '1');
INSERT INTO `lk_airport` VALUES ('1114', '突尼斯机场', '401', '1');
INSERT INTO `lk_airport` VALUES ('1115', '合肥骆岗机场', '69', '1');
INSERT INTO `lk_airport` VALUES ('1116', '奥兰多机场', '382', '1');
INSERT INTO `lk_airport` VALUES ('1117', '高雄机场', '317', '1');
INSERT INTO `lk_airport` VALUES ('1118', '尼雷尔机场', '394', '1');
INSERT INTO `lk_airport` VALUES ('1119', '三亚凤凰机场', '145', '1');
INSERT INTO `lk_airport` VALUES ('1120', '南宁吴圩机场', '127', '1');
INSERT INTO `lk_airport` VALUES ('1121', '费城机场', '374', '1');
INSERT INTO `lk_airport` VALUES ('1122', '毛里求斯机场', '393', '1');
INSERT INTO `lk_airport` VALUES ('1123', '明尼阿波利斯―圣保罗机场', '373', '1');
INSERT INTO `lk_airport` VALUES ('1124', '金海机场', '315', '1');
INSERT INTO `lk_airport` VALUES ('1125', '阿德莱德机场', '416', '1');
INSERT INTO `lk_airport` VALUES ('1126', '石家庄正定机场', '144', '1');
INSERT INTO `lk_airport` VALUES ('1127', '烟台莱山机场', '194', '1');
INSERT INTO `lk_airport` VALUES ('1128', '阿比让', '410', '1');
INSERT INTO `lk_airport` VALUES ('1129', '休斯敦机场', '368', '1');
INSERT INTO `lk_airport` VALUES ('1130', '银川河东机场', '183', '1');
INSERT INTO `lk_airport` VALUES ('1131', '兰州机场', '103', '1');
INSERT INTO `lk_airport` VALUES ('1132', '乌兰巴托机场', '324', '1');
INSERT INTO `lk_airport` VALUES ('1133', '福州长乐机场', '50', '1');
INSERT INTO `lk_airport` VALUES ('1134', '西宁曹家堡机场', '180', '1');
INSERT INTO `lk_airport` VALUES ('1135', '拉萨贡嘎机场', '109', '1');
INSERT INTO `lk_airport` VALUES ('1136', '桂林两江机场', '61', '1');
INSERT INTO `lk_airport` VALUES ('1137', '埃德蒙顿市中心机场', '385', '1');
INSERT INTO `lk_airport` VALUES ('1138', '澳门机场', '210', '1');
INSERT INTO `lk_airport` VALUES ('1139', '湛江机场', '204', '1');
INSERT INTO `lk_airport` VALUES ('1140', '杜阿拉机场', '408', '1');
INSERT INTO `lk_airport` VALUES ('1141', '金沙萨恩吉利机场', '406', '1');
INSERT INTO `lk_airport` VALUES ('1142', '爱丁堡机场', '346', '1');
INSERT INTO `lk_airport` VALUES ('1143', '徐州观音机场', '181', '1');
INSERT INTO `lk_airport` VALUES ('1144', 'CALGARY机场', '379', '1');
INSERT INTO `lk_airport` VALUES ('1145', '威海文登大水泊机场', '163', '1');
INSERT INTO `lk_airport` VALUES ('1146', '渥太华机场', '376', '1');
INSERT INTO `lk_airport` VALUES ('1147', '福冈机场', '318', '1');
INSERT INTO `lk_airport` VALUES ('1148', '佳木斯机场', '86', '1');
INSERT INTO `lk_airport` VALUES ('1149', '呼和浩特白塔国际机场', '68', '1');
INSERT INTO `lk_airport` VALUES ('1150', '马普托机场', '407', '1');
INSERT INTO `lk_airport` VALUES ('1151', '达尔文机场', '425', '1');
INSERT INTO `lk_airport` VALUES ('1152', '无锡硕放机场', '169', '1');
INSERT INTO `lk_airport` VALUES ('1153', '义乌机场', '192', '1');
INSERT INTO `lk_airport` VALUES ('1154', '景洪(西双版纳)机场', '174', '1');
INSERT INTO `lk_airport` VALUES ('1155', '珠海三灶机场', '207', '1');
INSERT INTO `lk_airport` VALUES ('1156', '大庆萨尔图机场', '43', '1');
INSERT INTO `lk_airport` VALUES ('1157', '喀什机场', '95', '1');
INSERT INTO `lk_airport` VALUES ('1158', '黄金海岸机场', '422', '1');
INSERT INTO `lk_airport` VALUES ('1159', '宜昌三峡机场', '190', '1');
INSERT INTO `lk_airport` VALUES ('1160', '宜宾(菜坝)机场', '187', '1');
INSERT INTO `lk_airport` VALUES ('1161', '柳州白莲机场', '114', '1');
INSERT INTO `lk_airport` VALUES ('1162', '临沂沭埠岭机场', '113', '1');
INSERT INTO `lk_airport` VALUES ('1163', '堪培拉机场', '419', '1');
INSERT INTO `lk_airport` VALUES ('1164', '纽卡斯尔机场', '348', '1');
INSERT INTO `lk_airport` VALUES ('1165', '鄂尔多斯伊金霍洛机场', '46', '1');
INSERT INTO `lk_airport` VALUES ('1166', '包头二里半机场', '12', '1');
INSERT INTO `lk_airport` VALUES ('1167', '普吉机场', '311', '1');
INSERT INTO `lk_airport` VALUES ('1168', '牡丹江海浪机场', '117', '1');
INSERT INTO `lk_airport` VALUES ('1169', '阿克苏机场', '3', '1');
INSERT INTO `lk_airport` VALUES ('1170', '丽江三义机场', '105', '1');
INSERT INTO `lk_airport` VALUES ('1171', '锦州小岭子机场', '88', '1');
INSERT INTO `lk_airport` VALUES ('1172', '延吉朝阳川机场', '193', '1');
INSERT INTO `lk_airport` VALUES ('1173', '丹东浪头机场', '37', '1');
INSERT INTO `lk_airport` VALUES ('1174', '泉州晋江机场', '85', '1');
INSERT INTO `lk_airport` VALUES ('1175', '惠灵顿机场', '418', '1');
INSERT INTO `lk_airport` VALUES ('1176', '潍坊机场', '162', '1');
INSERT INTO `lk_airport` VALUES ('1177', '常州奔牛机场', '31', '1');
INSERT INTO `lk_airport` VALUES ('1178', '连云港白塔埠机场', '112', '1');
INSERT INTO `lk_airport` VALUES ('1179', '佛山沙堤机场', '52', '1');
INSERT INTO `lk_airport` VALUES ('1180', '洛阳机场', '111', '1');
INSERT INTO `lk_airport` VALUES ('1181', '内蒙古海拉尔东山机场', '73', '1');
INSERT INTO `lk_airport` VALUES ('1182', '齐齐哈尔三家子机场', '136', '1');
INSERT INTO `lk_airport` VALUES ('1183', '北海福城机场', '14', '1');
INSERT INTO `lk_airport` VALUES ('1184', '揭阳潮汕机场', '91', '1');
INSERT INTO `lk_airport` VALUES ('1185', '秦皇岛山海关机场', '137', '1');
INSERT INTO `lk_airport` VALUES ('1186', '襄阳刘集机场', '175', '1');
INSERT INTO `lk_airport` VALUES ('1187', '绵阳南郊机场', '118', '1');
INSERT INTO `lk_airport` VALUES ('1188', '哈密机场', '74', '1');
INSERT INTO `lk_airport` VALUES ('1189', '嘉峪关机场', '81', '1');
INSERT INTO `lk_airport` VALUES ('1190', '凯恩斯机场', '420', '1');
INSERT INTO `lk_airport` VALUES ('1191', '南通兴东机场', '129', '1');
INSERT INTO `lk_airport` VALUES ('1192', '张家界荷花机场', '199', '1');
INSERT INTO `lk_airport` VALUES ('1193', '武夷山机场', '168', '1');
INSERT INTO `lk_airport` VALUES ('1194', '攀枝花保安营机场', '130', '1');
INSERT INTO `lk_airport` VALUES ('1195', '南阳姜营机场', '128', '1');
INSERT INTO `lk_airport` VALUES ('1196', '赣州黄金机场', '59', '1');
INSERT INTO `lk_airport` VALUES ('1197', '台州路桥(原黄岩路桥)机场', '149', '1');
INSERT INTO `lk_airport` VALUES ('1198', '山西大同机场', '34', '1');
INSERT INTO `lk_airport` VALUES ('1199', '伊宁机场', '191', '1');
INSERT INTO `lk_airport` VALUES ('1200', '遵义机场', '208', '1');
INSERT INTO `lk_airport` VALUES ('1201', '江苏盐城南洋机场', '195', '1');
INSERT INTO `lk_airport` VALUES ('1202', '库尔勒机场', '99', '1');
INSERT INTO `lk_airport` VALUES ('1203', '九江庐山机场', '84', '1');
INSERT INTO `lk_airport` VALUES ('1204', '西昌青山机场', '176', '1');
INSERT INTO `lk_airport` VALUES ('1205', '榆林西沙机场', '186', '1');
INSERT INTO `lk_airport` VALUES ('1206', '艾塞尼亚机场', '382', '1');
INSERT INTO `lk_airport` VALUES ('1207', '扬州泰州机场', '196', '1');
INSERT INTO `lk_airport` VALUES ('1208', '泸州蓝田机场', '115', '1');
INSERT INTO `lk_airport` VALUES ('1209', '卢克索机场', '411', '1');
INSERT INTO `lk_airport` VALUES ('1210', '札幌机场', '322', '1');
INSERT INTO `lk_airport` VALUES ('1211', '南充高坪机场', '123', '1');
INSERT INTO `lk_airport` VALUES ('1212', '大理荒草坝机场', '40', '1');
INSERT INTO `lk_airport` VALUES ('1213', '湖南永州零陵机场', '185', '1');
INSERT INTO `lk_airport` VALUES ('1214', '黄山屯溪机场', '78', '1');
INSERT INTO `lk_airport` VALUES ('1215', '呼伦贝尔满洲里西郊机场', '120', '1');
INSERT INTO `lk_airport` VALUES ('1216', '衢州机场', '135', '1');
INSERT INTO `lk_airport` VALUES ('1217', '唐山三女河机场', '158', '1');
INSERT INTO `lk_airport` VALUES ('1218', '巴厘', '309', '1');
INSERT INTO `lk_airport` VALUES ('1219', '乌兰浩特机场', '160', '1');
INSERT INTO `lk_airport` VALUES ('1220', '贵州黎平机场', '101', '1');
INSERT INTO `lk_airport` VALUES ('1221', '常德桃花源(斗姆湖)机场', '22', '1');
INSERT INTO `lk_airport` VALUES ('1222', '格尔木机场', '56', '1');
INSERT INTO `lk_airport` VALUES ('1223', '济州机场', '321', '1');
INSERT INTO `lk_airport` VALUES ('1224', '恩施机场', '48', '1');
INSERT INTO `lk_airport` VALUES ('1225', '阜阳西关机场', '51', '1');
INSERT INTO `lk_airport` VALUES ('1226', '淮安涟水机场', '71', '1');
INSERT INTO `lk_airport` VALUES ('1227', '景德镇罗家机场', '79', '1');
INSERT INTO `lk_airport` VALUES ('1228', '二连浩特赛乌苏国际机场', '49', '1');
INSERT INTO `lk_airport` VALUES ('1229', '林芝机场', '116', '1');
INSERT INTO `lk_airport` VALUES ('1230', '通辽机场', '153', '1');
INSERT INTO `lk_airport` VALUES ('1231', '巴厘岛', '309', '1');
INSERT INTO `lk_airport` VALUES ('1232', '怀化芷江机场', '72', '1');
INSERT INTO `lk_airport` VALUES ('1233', '河北邯郸机场机场', '66', '1');
INSERT INTO `lk_airport` VALUES ('1234', '运城关公机场', '188', '1');
INSERT INTO `lk_airport` VALUES ('1235', '巴彦淖尔天吉泰机场', '18', '1');
INSERT INTO `lk_airport` VALUES ('1236', '敦煌机场', '41', '1');
INSERT INTO `lk_airport` VALUES ('1237', '鸡西兴凯湖机场', '89', '1');
INSERT INTO `lk_airport` VALUES ('1238', '克拉玛依机场', '100', '1');
INSERT INTO `lk_airport` VALUES ('1239', '荆州沙市机场', '143', '1');
INSERT INTO `lk_airport` VALUES ('1240', '茨城机场', '326', '1');
INSERT INTO `lk_airport` VALUES ('1241', '中卫(香山、沙坡头)机场', '205', '1');
INSERT INTO `lk_airport` VALUES ('1242', '汉中西关机场', '77', '1');
INSERT INTO `lk_airport` VALUES ('1243', '青海玉树三江源(巴塘)机场', '197', '1');
INSERT INTO `lk_airport` VALUES ('1244', '重庆万州五桥机场', '171', '1');
INSERT INTO `lk_airport` VALUES ('1245', '锡林浩特机场', '177', '1');
INSERT INTO `lk_airport` VALUES ('1246', '安庆(天柱山)机场', '5', '1');
INSERT INTO `lk_airport` VALUES ('1247', '济宁机场', '87', '1');
INSERT INTO `lk_airport` VALUES ('1248', '霍巴特机场', '424', '1');
INSERT INTO `lk_airport` VALUES ('1249', '赤峰玉龙机场', '25', '1');
INSERT INTO `lk_airport` VALUES ('1250', '黑河机场', '67', '1');
INSERT INTO `lk_airport` VALUES ('1251', '长白山机场', '33', '1');
INSERT INTO `lk_airport` VALUES ('1252', '塞班机场', '371', '1');
INSERT INTO `lk_airport` VALUES ('1253', '和田机场', '76', '1');
INSERT INTO `lk_airport` VALUES ('1254', '腾冲(驼峰)机场', '151', '1');
INSERT INTO `lk_airport` VALUES ('1255', '漠河古莲机场', '121', '1');
INSERT INTO `lk_airport` VALUES ('1256', '长治王村机场', '26', '1');
INSERT INTO `lk_airport` VALUES ('1257', '通化机场', '156', '1');
INSERT INTO `lk_airport` VALUES ('1258', '库车机场', '93', '1');
INSERT INTO `lk_airport` VALUES ('1259', '金昌机场', '83', '1');
INSERT INTO `lk_airport` VALUES ('1260', '舟山普陀山朱家尖机场', '200', '1');
INSERT INTO `lk_airport` VALUES ('1261', '井冈山机场', '82', '1');
INSERT INTO `lk_airport` VALUES ('1262', '甘肃天水机场', '154', '1');
INSERT INTO `lk_airport` VALUES ('1263', '云南文山普者黑机场', '164', '1');
INSERT INTO `lk_airport` VALUES ('1264', '临沧机场', '108', '1');
INSERT INTO `lk_airport` VALUES ('1265', '庆阳机场', '133', '1');
INSERT INTO `lk_airport` VALUES ('1266', '昭通机场', '202', '1');
INSERT INTO `lk_airport` VALUES ('1267', '广元机场', '57', '1');
INSERT INTO `lk_airport` VALUES ('1268', '伊春林都机场', '184', '1');
INSERT INTO `lk_airport` VALUES ('1269', '吐鲁番交河机场', '155', '1');
INSERT INTO `lk_airport` VALUES ('1270', '康定机场', '94', '1');
INSERT INTO `lk_airport` VALUES ('1271', '铜仁凤凰机场', '152', '1');
INSERT INTO `lk_airport` VALUES ('1272', '广汉机场', '55', '1');
INSERT INTO `lk_airport` VALUES ('1273', '鞍山机场', '4', '1');
INSERT INTO `lk_airport` VALUES ('1274', '福建龙岩冠豸山机场', '102', '1');
INSERT INTO `lk_airport` VALUES ('1275', '扬', '196', '1');
INSERT INTO `lk_airport` VALUES ('1276', '安康机场', '2', '1');
INSERT INTO `lk_airport` VALUES ('1277', '贵州安顺黄果树机场', '6', '1');
INSERT INTO `lk_airport` VALUES ('1278', '普洱(思茅)机场', '131', '1');
INSERT INTO `lk_airport` VALUES ('1279', '且末机场', '132', '1');
INSERT INTO `lk_airport` VALUES ('1280', '迪庆香格里拉机场', '38', '1');
INSERT INTO `lk_airport` VALUES ('1281', '九寨沟黄龙(九黄)机场', '90', '1');
INSERT INTO `lk_airport` VALUES ('1282', '阿勒泰机场', '1', '1');
INSERT INTO `lk_airport` VALUES ('1283', '广西梧州长洲岛机场', '170', '1');
INSERT INTO `lk_airport` VALUES ('1284', '辽宁朝阳机场', '24', '1');
INSERT INTO `lk_airport` VALUES ('1285', '西藏昌都邦达机场', '21', '1');
INSERT INTO `lk_airport` VALUES ('1286', '延安二十里铺机场', '182', '1');
INSERT INTO `lk_airport` VALUES ('1287', '阿勒', '1', '1');
INSERT INTO `lk_airport` VALUES ('1288', '张掖机场', '201', '1');
INSERT INTO `lk_airport` VALUES ('1289', '新疆博乐机场', '15', '1');
INSERT INTO `lk_airport` VALUES ('1290', '日喀则和平机场', '139', '1');
INSERT INTO `lk_airport` VALUES ('1291', '宁夏固原六盘山机场', '58', '1');
INSERT INTO `lk_airport` VALUES ('1292', '乌海机场', '166', '1');
INSERT INTO `lk_airport` VALUES ('1293', '保山云瑞机场', '16', '1');
INSERT INTO `lk_airport` VALUES ('1294', '那拉提机场', '126', '1');
INSERT INTO `lk_airport` VALUES ('1295', '长海(大长山岛)机场', '28', '1');
INSERT INTO `lk_airport` VALUES ('1296', '东营永安机场', '42', '1');
INSERT INTO `lk_airport` VALUES ('1297', '荔波机场', '106', '1');
INSERT INTO `lk_airport` VALUES ('1298', '广西百色(田阳)机场', '11', '1');
INSERT INTO `lk_airport` VALUES ('1299', '达尼丁', '426', '1');
INSERT INTO `lk_airport` VALUES ('1300', '黔江舟白机场', '134', '1');
INSERT INTO `lk_airport` VALUES ('1301', '塔城机场', '150', '1');
INSERT INTO `lk_airport` VALUES ('1302', '阿里昆莎机场', '8', '1');
INSERT INTO `lk_airport` VALUES ('1303', '黎', '101', '1');
INSERT INTO `lk_airport` VALUES ('1304', '苏', '339', '1');
INSERT INTO `lk_airport` VALUES ('1305', '帕', '423', '1');
INSERT INTO `lk_airport` VALUES ('1306', '新疆喀纳斯机场', '97', '1');
INSERT INTO `lk_airport` VALUES ('1307', '阿尔山伊尔施机场', '10', '1');
INSERT INTO `lk_airport` VALUES ('1308', '兴义机场', '172', '1');
INSERT INTO `lk_airport` VALUES ('1309', '蒙特利尔机场', '369', '1');
INSERT INTO `lk_airport` VALUES ('1310', '温哥华机场', '360', '1');
INSERT INTO `lk_airport` VALUES ('1311', '华盛顿', '364', '1');
INSERT INTO `lk_airport` VALUES ('1312', '圣保罗', '375', '1');
INSERT INTO `lk_airport` VALUES ('1313', '北海', '14', '1');
INSERT INTO `lk_airport` VALUES ('1314', '罗马', '331', '1');
INSERT INTO `lk_airport` VALUES ('1315', '华盛顿', '364', '1');
INSERT INTO `lk_airport` VALUES ('1316', '巴黎', '328', '1');
INSERT INTO `lk_airport` VALUES ('1317', '珀斯', '417', '1');
INSERT INTO `lk_airport` VALUES ('1318', '波特兰', '383', '1');
INSERT INTO `lk_airport` VALUES ('1319', '卡萨布兰卡', '399', '1');
INSERT INTO `lk_airport` VALUES ('1320', '华盛顿', '364', '1');
INSERT INTO `lk_airport` VALUES ('1321', '芝加哥', '361', '1');
INSERT INTO `lk_airport` VALUES ('1322', '奥克兰', '414', '1');
INSERT INTO `lk_airport` VALUES ('1323', '底特律', '366', '1');
INSERT INTO `lk_airport` VALUES ('1324', '雅典', '345', '1');
INSERT INTO `lk_airport` VALUES ('1325', '圣保罗', '375', '1');
INSERT INTO `lk_airport` VALUES ('1326', '纽卡斯尔', '348', '1');
INSERT INTO `lk_airport` VALUES ('1327', '哥本哈根', '341', '1');
INSERT INTO `lk_airport` VALUES ('1328', '东京', '300', '1');
INSERT INTO `lk_airport` VALUES ('1329', '伦敦', '327', '1');
INSERT INTO `lk_airport` VALUES ('1330', '斯德哥尔摩', '335', '1');
INSERT INTO `lk_airport` VALUES ('1331', '罗马', '331', '1');
INSERT INTO `lk_airport` VALUES ('1332', '名古屋', '310', '1');
INSERT INTO `lk_airport` VALUES ('1333', '布宜诺斯艾利斯', '386', '1');
INSERT INTO `lk_airport` VALUES ('1334', '格拉斯哥', '351', '1');
INSERT INTO `lk_airport` VALUES ('1335', '格拉斯哥', '351', '1');
INSERT INTO `lk_airport` VALUES ('1336', '曼彻斯特', '337', '1');
INSERT INTO `lk_airport` VALUES ('1337', '波特兰', '383', '1');
INSERT INTO `lk_airport` VALUES ('1338', '首尔', '301', '1');
INSERT INTO `lk_airport` VALUES ('1339', '首尔', '301', '1');
INSERT INTO `lk_airport` VALUES ('1340', '斯德哥尔摩', '335', '1');
INSERT INTO `lk_airport` VALUES ('1341', '米兰', '333', '1');
INSERT INTO `lk_airport` VALUES ('1342', '巴黎', '328', '1');
INSERT INTO `lk_airport` VALUES ('1343', '伦敦', '327', '1');
INSERT INTO `lk_airport` VALUES ('1344', '布宜诺斯艾利斯', '386', '1');
INSERT INTO `lk_airport` VALUES ('1345', '伦敦', '327', '1');
INSERT INTO `lk_airport` VALUES ('1346', '华盛顿', '364', '1');
INSERT INTO `lk_airport` VALUES ('1347', '柏林', '336', '1');
INSERT INTO `lk_airport` VALUES ('1348', '巴厘岛', '309', '1');
INSERT INTO `lk_airport` VALUES ('1349', '圣保罗', '375', '1');
INSERT INTO `lk_airport` VALUES ('1350', '米兰', '333', '1');
INSERT INTO `lk_airport` VALUES ('1351', '多伦多', '362', '1');
INSERT INTO `lk_airport` VALUES ('1352', '斯德哥尔摩', '335', '1');
INSERT INTO `lk_airport` VALUES ('1353', '罗马', '331', '1');
INSERT INTO `lk_airport` VALUES ('1354', '雅典', '345', '1');
INSERT INTO `lk_airport` VALUES ('1355', '吉隆坡苏丹阿卜杜尔机场', '304', '1');
INSERT INTO `lk_airport` VALUES ('1356', 'CALGARY机场', '379', '1');
INSERT INTO `lk_airport` VALUES ('1357', '米兰利纳特机场', '333', '1');
INSERT INTO `lk_airport` VALUES ('1358', '柏林勃兰登堡机场', '336', '1');
INSERT INTO `lk_airport` VALUES ('1359', '底特律都会韦恩县机场', '366', '1');
INSERT INTO `lk_airport` VALUES ('1360', '赫登机场', '382', '1');
INSERT INTO `lk_airport` VALUES ('1361', '斯德哥尔摩史卡夫斯塔机场', '335', '1');
INSERT INTO `lk_airport` VALUES ('1362', '华盛顿杜勒斯机场', '364', '1');
INSERT INTO `lk_airport` VALUES ('1363', '巴黎-奥利机场', '328', '1');
INSERT INTO `lk_airport` VALUES ('1364', 'Hamburg Finkenwerder机场', '354', '1');
INSERT INTO `lk_airport` VALUES ('1365', '法兰克福哈恩机场', '329', '1');
INSERT INTO `lk_airport` VALUES ('1366', '普雷斯蒂克机场', '351', '1');
INSERT INTO `lk_airport` VALUES ('1367', '加州奥克兰机场', '414', '1');
INSERT INTO `lk_airport` VALUES ('1368', '罗纳德・里根机场', '364', '1');
INSERT INTO `lk_airport` VALUES ('1369', '芝加哥中途机场', '361', '1');
INSERT INTO `lk_airport` VALUES ('1370', '盖特威克机场', '327', '1');
INSERT INTO `lk_airport` VALUES ('1371', '萨比哈・格克琴机场', '323', '1');
INSERT INTO `lk_airport` VALUES ('1372', '北九州机场', '318', '1');
INSERT INTO `lk_airport` VALUES ('1373', '莫斯科机场', '330', '1');
INSERT INTO `lk_airport` VALUES ('1374', '巴黎机场', '328', '1');
INSERT INTO `lk_airport` VALUES ('1375', '罗马机场', '331', '1');
INSERT INTO `lk_airport` VALUES ('1376', '墨尔本机场', '413', '1');
INSERT INTO `lk_airport` VALUES ('1377', '悉尼金斯福德・史密斯机场', '412', '1');
INSERT INTO `lk_airport` VALUES ('1378', '多伦多市中心机场', '362', '1');
INSERT INTO `lk_airport` VALUES ('1379', '多伦多皮尔逊机场', '362', '1');
INSERT INTO `lk_airport` VALUES ('1380', '伏努科沃机场', '330', '1');
INSERT INTO `lk_airport` VALUES ('1381', '多莫杰多沃机场', '330', '1');
INSERT INTO `lk_airport` VALUES ('1382', '滕伯尔霍夫机场', '336', '1');
INSERT INTO `lk_airport` VALUES ('1383', '埃塞萨皮斯塔里尼部长机场', '386', '1');
INSERT INTO `lk_airport` VALUES ('1384', '伦敦卢顿机场', '327', '1');
INSERT INTO `lk_airport` VALUES ('1385', '波里斯珀尔机场', '352', '1');
INSERT INTO `lk_airport` VALUES ('1386', '伦敦城市机场', '327', '1');
INSERT INTO `lk_airport` VALUES ('1387', '埃德蒙顿机场', '385', '1');
INSERT INTO `lk_airport` VALUES ('1388', '威廉斯敦机场', '348', '1');
INSERT INTO `lk_airport` VALUES ('1389', '米拉贝尔机场', '369', '1');
INSERT INTO `lk_airport` VALUES ('1390', '桃园/桃園(原中正)机场', '211', '1');
INSERT INTO `lk_airport` VALUES ('1391', '奥兰多桑福德机场', '382', '1');
INSERT INTO `lk_airport` VALUES ('1392', '伯明翰舒特尔斯沃思机场', '347', '1');
INSERT INTO `lk_airport` VALUES ('1393', '舍讷费尔德机场', '336', '1');
INSERT INTO `lk_airport` VALUES ('1394', '波音场国王郡立机场', '363', '1');
INSERT INTO `lk_airport` VALUES ('1395', '雅加达机场', '306', '1');
INSERT INTO `lk_airport` VALUES ('1396', '伦敦斯坦斯特德机场', '327', '1');

-- ----------------------------
-- Table structure for lk_airport_city
-- ----------------------------
DROP TABLE IF EXISTS `lk_airport_city`;
CREATE TABLE `lk_airport_city` (
  `city_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `city_name` varchar(10) NOT NULL DEFAULT '',
  `initial` char(1) NOT NULL DEFAULT '' COMMENT '首字母',
  `airport_code` varchar(5) NOT NULL DEFAULT '' COMMENT '机场代码',
  `is_hot` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否热门 1是 0否',
  `is_inter__hot` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否国外热门 1是 0否',
  PRIMARY KEY (`city_id`)
) ENGINE=MyISAM AUTO_INCREMENT=209 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of lk_airport_city
-- ----------------------------
INSERT INTO `lk_airport_city` VALUES ('24', '朝阳', 'C', 'CHG', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('182', '延安', 'Y', 'ENY', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('165', '温州', 'W', 'WNZ', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('36', '稻城', 'D', 'DCY', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('111', '洛阳', 'L', 'LYA', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('201', '张掖', 'Z', 'YZY', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('128', '南阳', 'N', 'NNY', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('136', '齐齐哈尔', 'Q', 'NDG', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('114', '柳州', 'L', 'LZH', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('105', '丽江', 'L', 'LJG', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('100', '克拉玛依', 'K', 'KRY', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('14', '北海', 'B', 'BHY', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('192', '义乌', 'Y', 'YIW', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('123', '南充', 'N', 'NAO', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('96', '凯里', 'K', 'KJH', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('121', '漠河', 'M', 'OHE', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('38', '迪庆', 'D', 'DIG', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('207', '珠海', 'Z', 'ZUH', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('157', '天津', 'T', 'TSN', '1', '1');
INSERT INTO `lk_airport_city` VALUES ('1', '阿勒泰', 'A', 'AAT', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('110', '林西', 'L', 'LXI', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('97', '喀纳斯', 'K', 'KJI', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('23', '长春', 'C', 'CGQ', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('155', '吐鲁番', 'T', 'TLQ', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('175', '襄阳', 'X', 'XFN', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('191', '伊宁市', 'Y', 'YIN', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('108', '临沧', 'L', 'LNJ', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('8', '阿里', 'A', 'NGQ', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('78', '黄山', 'H', 'TXN', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('37', '丹东', 'D', 'DDG', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('164', '文山县', 'W', 'WNH', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('122', '南昌', 'N', 'KHN', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('193', '延吉', 'Y', 'YNJ', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('197', '玉树县', 'Y', 'YUS', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('171', '万州', 'W', 'WXN', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('204', '湛江', 'Z', 'ZHA', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('152', '铜仁市', 'T', 'TEN', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('135', '衢州', 'Q', 'JUZ', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('150', '塔城', 'T', 'TCG', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('58', '固原', 'G', 'GYU', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('143', '沙市', 'S', 'SHS', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('76', '和田市', 'H', 'HTN', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('125', '南京', 'N', 'NKG', '1', '1');
INSERT INTO `lk_airport_city` VALUES ('115', '泸州', 'L', 'LZO', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('183', '银川', 'Y', 'INC', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('109', '拉萨', 'L', 'LXA', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('139', '日喀则', 'R', 'RKZ', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('2', '安康', 'A', 'AKA', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('89', '鸡西', 'J', 'JXA', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('90', '九寨沟', 'J', 'JZH', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('45', '德宏', 'D', 'LUM', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('83', '金昌', 'J', 'JIC', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('162', '潍坊', 'W', 'WEF', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('166', '乌海', 'W', 'WUA', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('46', '鄂尔多斯', 'E', 'DSN', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('178', '西安', 'X', 'SIA', '1', '1');
INSERT INTO `lk_airport_city` VALUES ('103', '兰州', 'L', 'LHW', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('159', '太原', 'T', 'TYN', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('73', '海拉尔', 'H', 'HLD', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('86', '佳木斯', 'J', 'JMU', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('149', '台州', 'T', 'HYN', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('133', '庆阳', 'Q', 'IQN', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('198', '郑州', 'Z', 'CGO', '1', '0');
INSERT INTO `lk_airport_city` VALUES ('74', '哈密市', 'H', 'HMI', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('9', '阿拉善右旗', 'A', 'RHT', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('55', '广汉', 'G', 'GHN', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('6', '安顺', 'A', 'AVA', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('84', '九江', 'J', 'JIU', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('205', '中卫', 'Z', 'ZHY', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('95', '喀什市', 'K', 'KHG', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('187', '宜宾', 'Y', 'YBP', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('69', '合肥', 'H', 'HFE', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('80', '加格达奇', 'J', 'JGD', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('206', '张家口', 'Z', 'ZQZ', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('172', '兴义', 'X', 'ACX', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('138', '青岛', 'Q', 'TAO', '1', '1');
INSERT INTO `lk_airport_city` VALUES ('64', '海口', 'H', 'HAK', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('63', '红原', 'H', 'AHJ', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('154', '天水', 'T', 'THQ', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('21', '昌都', 'C', 'BPX', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('68', '呼和浩特', 'H', 'HET', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('163', '威海', 'W', 'WEH', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('82', '井冈山', 'J', 'JGS', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('101', '黎平', 'L', 'HZH', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('53', '抚远', 'F', 'FYJ', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('127', '南宁', 'N', 'NNG', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('129', '南通', 'N', 'NTG', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('62', '光化', 'G', 'LHK', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('15', '博乐', 'B', 'BPL', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('142', '沈阳', 'S', 'SHE', '0', '1');
INSERT INTO `lk_airport_city` VALUES ('176', '西昌', 'X', 'XIC', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('85', '晋江', 'J', 'JJN', '0', '1');
INSERT INTO `lk_airport_city` VALUES ('181', '徐州', 'X', 'XUZ', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('102', '龙岩', 'L', 'LCX', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('42', '东营', 'D', 'DOY', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('119', '梅州', 'M', 'MXZ', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('87', '济宁', 'J', 'JNG', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('94', '康定', 'K', 'KGT', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('16', '保山', 'B', 'BSD', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('177', '锡林浩特', 'X', 'XIL', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('39', '大连', 'D', 'DLC', '1', '1');
INSERT INTO `lk_airport_city` VALUES ('184', '伊春', 'Y', 'LDS', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('61', '桂林', 'G', 'KWL', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('161', '乌鲁木齐', 'W', 'URC', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('26', '长治', 'C', 'CIH', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('13', '毕节', 'B', 'BFJ', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('126', '那拉提', 'N', 'NLT', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('60', '贵阳', 'G', 'KWE', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('44', '德令哈', 'D', 'HXD', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('17', '北京', 'B', 'BJS', '1', '1');
INSERT INTO `lk_airport_city` VALUES ('72', '怀化', 'H', 'HJJ', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('116', '林芝', 'L', 'LZY', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('10', '阿尔山', 'A', 'YIE', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('106', '荔波', 'L', 'LLB', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('12', '包头', 'B', 'BAV', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('169', '无锡', 'W', 'WUX', '0', '1');
INSERT INTO `lk_airport_city` VALUES ('57', '广元', 'G', 'GYS', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('27', '重庆', 'C', 'CKG', '1', '1');
INSERT INTO `lk_airport_city` VALUES ('70', '杭州', 'H', 'HGH', '1', '1');
INSERT INTO `lk_airport_city` VALUES ('99', '库尔勒', 'K', 'KRL', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('4', '鞍山', 'A', 'AOG', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('34', '大同', 'D', 'DAT', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('120', '满洲里', 'M', 'NZH', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('18', '巴彦淖尔', 'B', 'RLK', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('130', '攀枝花', 'P', 'PZI', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('25', '赤峰', 'C', 'CIF', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('81', '嘉峪关', 'J', 'JGN', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('195', '盐城', 'Y', 'YNZ', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('93', '库车', 'K', 'KCA', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('88', '锦州', 'J', 'JNZ', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('131', '普洱', 'P', 'SYM', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('104', '梁平', 'L', 'LIA', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('5', '安庆', 'A', 'AQG', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('140', '神农架', 'S', 'HPG', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('170', '梧州', 'W', 'WUZ', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('11', '百色', 'B', 'AEB', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('113', '临沂', 'L', 'LYI', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('153', '通辽', 'T', 'TGO', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('202', '昭通', 'Z', 'ZAT', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('180', '西宁', 'X', 'XNN', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('141', '上海', 'S', 'SHA', '1', '1');
INSERT INTO `lk_airport_city` VALUES ('137', '秦皇岛', 'Q', 'SHP', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('28', '长海', 'C', 'CNI', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('118', '绵阳', 'M', 'MIG', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('71', '淮安', 'H', 'HIA', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('35', '达县', 'D', 'DAX', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('92', '济南', 'J', 'TNA', '1', '0');
INSERT INTO `lk_airport_city` VALUES ('50', '福州', 'F', 'FOC', '1', '1');
INSERT INTO `lk_airport_city` VALUES ('112', '连云港', 'L', 'LYG', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('30', '成都', 'C', 'CTU', '1', '1');
INSERT INTO `lk_airport_city` VALUES ('65', '河池', 'H', 'HCJ', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('194', '烟台', 'Y', 'YNT', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('75', '哈尔滨', 'H', 'HRB', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('146', '深圳', 'S', 'SZX', '1', '1');
INSERT INTO `lk_airport_city` VALUES ('49', '二连浩特', 'E', 'ERL', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('188', '运城', 'Y', 'YCU', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('158', '唐山', 'T', 'TVS', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('47', '额济纳旗', 'E', 'EJN', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('144', '石家庄', 'S', 'SJW', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('31', '常州', 'C', 'CZX', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('186', '榆林', 'Y', 'UYN', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('199', '张家界', 'Z', 'DYG', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('22', '常德', 'C', 'CGD', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('203', '中山', 'Z', 'ZGN', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('185', '永州', 'Y', 'LLF', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('196', '扬州', 'Y', 'YTY', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('156', '通化', 'T', 'TNH', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('51', '阜阳', 'F', 'FUG', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('200', '舟山', 'Z', 'HSN', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('132', '且末', 'Q', 'IQM', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('98', '昆明', 'K', 'KMG', '1', '1');
INSERT INTO `lk_airport_city` VALUES ('3', '阿克苏', 'A', 'AKU', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('145', '三亚', 'S', 'SYX', '1', '1');
INSERT INTO `lk_airport_city` VALUES ('7', '阿拉善左旗', 'A', 'AXF', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('40', '大理市', 'D', 'DLU', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('179', '厦门', 'X', 'XMN', '1', '1');
INSERT INTO `lk_airport_city` VALUES ('151', '腾冲', 'T', 'TCZ', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('59', '赣州', 'G', 'KOW', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('167', '武汉', 'W', 'WUH', '1', '1');
INSERT INTO `lk_airport_city` VALUES ('48', '恩施', 'E', 'ENH', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('66', '邯郸', 'H', 'HDG', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('189', '宜春', 'Y', 'YIC', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('160', '乌兰浩特', 'W', 'HLH', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('173', '夏河', 'X', 'GXH', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('33', '长白山', 'C', 'NBS', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('41', '敦煌', 'D', 'DNH', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('29', '长沙', 'C', 'CSX', '1', '0');
INSERT INTO `lk_airport_city` VALUES ('56', '格尔木', 'G', 'GOQ', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('43', '大庆', 'D', 'DQA', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('91', '揭阳', 'J', 'SWA', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('52', '佛山', 'F', 'FUO', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('77', '汉中', 'H', 'HZG', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('168', '武夷山', 'W', 'WUS', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('174', '西双版纳', 'X', 'JHG', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('134', '黔江', 'Q', 'JIQ', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('107', '吕梁', 'L', 'LLV', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('32', '池州', 'C', 'JUH', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('79', '景德镇', 'J', 'JDZ', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('124', '宁波', 'N', 'NGB', '0', '1');
INSERT INTO `lk_airport_city` VALUES ('190', '宜昌', 'Y', 'YIH', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('67', '黑河', 'H', 'HEK', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('208', '遵义', 'Z', 'ZYI', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('117', '牡丹江', 'M', 'MDG', '0', '0');
INSERT INTO `lk_airport_city` VALUES ('54', '广州', 'G', 'CAN', '1', '1');

-- ----------------------------
-- Table structure for lk_airport_inter_city
-- ----------------------------
DROP TABLE IF EXISTS `lk_airport_inter_city`;
CREATE TABLE `lk_airport_inter_city` (
  `city_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `city_name` varchar(10) NOT NULL DEFAULT '',
  `airport_code` varchar(5) NOT NULL DEFAULT '' COMMENT '机场代码',
  `is_hot` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否热门 1是 0否',
  `continents` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1亚洲 2欧洲 3美洲 4非洲 5大洋洲',
  PRIMARY KEY (`city_id`)
) ENGINE=MyISAM AUTO_INCREMENT=427 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of lk_airport_inter_city
-- ----------------------------
INSERT INTO `lk_airport_inter_city` VALUES ('399', '卡萨布兰卡', 'CAS', '0', '4');
INSERT INTO `lk_airport_inter_city` VALUES ('412', '悉尼(澳大利亚)', 'SYD', '1', '5');
INSERT INTO `lk_airport_inter_city` VALUES ('330', '莫斯科', 'MOW', '0', '2');
INSERT INTO `lk_airport_inter_city` VALUES ('335', '斯德哥尔摩', 'STO', '0', '2');
INSERT INTO `lk_airport_inter_city` VALUES ('307', '胡志明市', 'SGN', '1', '1');
INSERT INTO `lk_airport_inter_city` VALUES ('351', '格拉斯哥', 'GLA', '0', '2');
INSERT INTO `lk_airport_inter_city` VALUES ('340', '布鲁塞尔', 'BRU', '0', '2');
INSERT INTO `lk_airport_inter_city` VALUES ('318', '福冈', 'FUK', '0', '1');
INSERT INTO `lk_airport_inter_city` VALUES ('312', '河内', 'HAN', '0', '1');
INSERT INTO `lk_airport_inter_city` VALUES ('406', '金沙萨', 'FIH', '0', '4');
INSERT INTO `lk_airport_inter_city` VALUES ('347', '伯明翰(英国)', 'BHX', '0', '2');
INSERT INTO `lk_airport_inter_city` VALUES ('419', '堪培拉', 'CBR', '0', '5');
INSERT INTO `lk_airport_inter_city` VALUES ('323', '伊斯坦布尔', 'IST', '0', '1');
INSERT INTO `lk_airport_inter_city` VALUES ('371', '塞班', 'SPN', '0', '3');
INSERT INTO `lk_airport_inter_city` VALUES ('370', '夏威夷', 'HNL', '1', '3');
INSERT INTO `lk_airport_inter_city` VALUES ('346', '爱丁堡', 'EDI', '0', '2');
INSERT INTO `lk_airport_inter_city` VALUES ('363', '西雅图', 'SEA', '0', '3');
INSERT INTO `lk_airport_inter_city` VALUES ('310', '名古屋', 'NGO', '1', '1');
INSERT INTO `lk_airport_inter_city` VALUES ('309', '巴厘岛', 'DPS', '0', '1');
INSERT INTO `lk_airport_inter_city` VALUES ('402', '卢萨卡', 'LUN', '0', '4');
INSERT INTO `lk_airport_inter_city` VALUES ('362', '多伦多', 'YTO', '0', '3');
INSERT INTO `lk_airport_inter_city` VALUES ('302', '新加坡', 'SIN', '1', '1');
INSERT INTO `lk_airport_inter_city` VALUES ('210', '澳门', 'MFM', '1', '1');
INSERT INTO `lk_airport_inter_city` VALUES ('392', '罗安达', 'LAD', '0', '4');
INSERT INTO `lk_airport_inter_city` VALUES ('344', '巴塞罗那', 'BCN', '0', '2');
INSERT INTO `lk_airport_inter_city` VALUES ('328', '巴黎', 'PAR', '1', '2');
INSERT INTO `lk_airport_inter_city` VALUES ('400', '德班', 'DUR', '0', '4');
INSERT INTO `lk_airport_inter_city` VALUES ('389', '开普敦', 'CPT', '0', '4');
INSERT INTO `lk_airport_inter_city` VALUES ('420', '凯恩斯', 'CNS', '0', '5');
INSERT INTO `lk_airport_inter_city` VALUES ('422', '黄金海岸', 'OOL', '0', '5');
INSERT INTO `lk_airport_inter_city` VALUES ('349', '日内瓦', 'GVA', '0', '2');
INSERT INTO `lk_airport_inter_city` VALUES ('353', '布达佩斯', 'BUD', '0', '2');
INSERT INTO `lk_airport_inter_city` VALUES ('395', '亚的斯亚贝巴', 'ADD', '0', '4');
INSERT INTO `lk_airport_inter_city` VALUES ('358', '洛杉矶', 'LAX', '1', '3');
INSERT INTO `lk_airport_inter_city` VALUES ('418', '惠灵顿', 'WLG', '0', '5');
INSERT INTO `lk_airport_inter_city` VALUES ('416', '阿德莱德', 'ADL', '0', '5');
INSERT INTO `lk_airport_inter_city` VALUES ('410', '阿比让', 'ABJ', '0', '4');
INSERT INTO `lk_airport_inter_city` VALUES ('386', '布宜诺斯艾利斯', 'BUE', '0', '4');
INSERT INTO `lk_airport_inter_city` VALUES ('211', '台北', 'TPE', '1', '1');
INSERT INTO `lk_airport_inter_city` VALUES ('315', '釜山', 'PUS', '1', '1');
INSERT INTO `lk_airport_inter_city` VALUES ('337', '曼彻斯特(英国)', 'MAN', '0', '2');
INSERT INTO `lk_airport_inter_city` VALUES ('426', '达尼丁', 'DUD', '0', '5');
INSERT INTO `lk_airport_inter_city` VALUES ('388', '约翰内斯堡', 'JNB', '0', '4');
INSERT INTO `lk_airport_inter_city` VALUES ('308', '马尼拉', 'MNL', '1', '1');
INSERT INTO `lk_airport_inter_city` VALUES ('342', '赫尔辛基', 'HEL', '0', '2');
INSERT INTO `lk_airport_inter_city` VALUES ('331', '罗马', 'ROM', '0', '2');
INSERT INTO `lk_airport_inter_city` VALUES ('397', '阿克拉', 'ACC', '0', '4');
INSERT INTO `lk_airport_inter_city` VALUES ('316', '加德满都', 'KTM', '0', '1');
INSERT INTO `lk_airport_inter_city` VALUES ('354', '汉堡', 'HAM', '0', '2');
INSERT INTO `lk_airport_inter_city` VALUES ('343', '维也纳', 'VIE', '0', '2');
INSERT INTO `lk_airport_inter_city` VALUES ('378', '拉斯维加斯', 'LAS', '0', '3');
INSERT INTO `lk_airport_inter_city` VALUES ('300', '东京', 'TYO', '1', '1');
INSERT INTO `lk_airport_inter_city` VALUES ('367', '亚特兰大', 'ATL', '0', '3');
INSERT INTO `lk_airport_inter_city` VALUES ('365', '波士顿', 'BOS', '0', '3');
INSERT INTO `lk_airport_inter_city` VALUES ('306', '雅加达', 'JKT', '0', '1');
INSERT INTO `lk_airport_inter_city` VALUES ('301', '首尔', 'SEL', '1', '1');
INSERT INTO `lk_airport_inter_city` VALUES ('366', '底特律', 'DTT', '0', '3');
INSERT INTO `lk_airport_inter_city` VALUES ('409', '费里敦', 'FNA', '0', '4');
INSERT INTO `lk_airport_inter_city` VALUES ('403', '哈拉雷', 'HRE', '0', '4');
INSERT INTO `lk_airport_inter_city` VALUES ('345', '雅典', 'ATH', '0', '2');
INSERT INTO `lk_airport_inter_city` VALUES ('361', '芝加哥', 'CHI', '0', '3');
INSERT INTO `lk_airport_inter_city` VALUES ('380', '迈阿密', 'MIA', '0', '3');
INSERT INTO `lk_airport_inter_city` VALUES ('381', '丹佛', 'DEN', '0', '3');
INSERT INTO `lk_airport_inter_city` VALUES ('407', '马普托', 'MPM', '0', '4');
INSERT INTO `lk_airport_inter_city` VALUES ('377', '墨西哥城', 'MEX', '0', '3');
INSERT INTO `lk_airport_inter_city` VALUES ('341', '哥本哈根', 'CPH', '0', '2');
INSERT INTO `lk_airport_inter_city` VALUES ('396', '喀土穆', 'KRT', '0', '4');
INSERT INTO `lk_airport_inter_city` VALUES ('408', '杜阿拉', 'DLA', '0', '4');
INSERT INTO `lk_airport_inter_city` VALUES ('332', '阿姆斯特丹', 'AMS', '0', '2');
INSERT INTO `lk_airport_inter_city` VALUES ('379', '卡尔加里', 'YYC', '0', '3');
INSERT INTO `lk_airport_inter_city` VALUES ('317', '高雄', 'KHH', '0', '1');
INSERT INTO `lk_airport_inter_city` VALUES ('320', '德里', 'DEL', '0', '1');
INSERT INTO `lk_airport_inter_city` VALUES ('338', '马德里', 'MAD', '0', '2');
INSERT INTO `lk_airport_inter_city` VALUES ('314', '迪拜', 'DXB', '0', '1');
INSERT INTO `lk_airport_inter_city` VALUES ('385', '埃德蒙顿', 'YEA', '0', '3');
INSERT INTO `lk_airport_inter_city` VALUES ('329', '法兰克福', 'FRA', '1', '2');
INSERT INTO `lk_airport_inter_city` VALUES ('324', '乌兰巴托', 'ULN', '0', '1');
INSERT INTO `lk_airport_inter_city` VALUES ('326', '茨城', 'IBR', '0', '1');
INSERT INTO `lk_airport_inter_city` VALUES ('360', '温哥华', 'YVR', '1', '3');
INSERT INTO `lk_airport_inter_city` VALUES ('303', '曼谷', 'BKK', '1', '1');
INSERT INTO `lk_airport_inter_city` VALUES ('393', '毛里求斯', 'MRU', '0', '4');
INSERT INTO `lk_airport_inter_city` VALUES ('359', '旧金山', 'SFO', '0', '3');
INSERT INTO `lk_airport_inter_city` VALUES ('311', '普吉岛', 'HKT', '0', '1');
INSERT INTO `lk_airport_inter_city` VALUES ('387', '开罗', 'CAI', '0', '4');
INSERT INTO `lk_airport_inter_city` VALUES ('209', '香港', 'HKG', '1', '1');
INSERT INTO `lk_airport_inter_city` VALUES ('368', '休斯敦', 'HOU', '0', '3');
INSERT INTO `lk_airport_inter_city` VALUES ('327', '伦敦(英国)', 'LON', '1', '2');
INSERT INTO `lk_airport_inter_city` VALUES ('333', '米兰', 'MIL', '0', '2');
INSERT INTO `lk_airport_inter_city` VALUES ('322', '札幌', 'SPK', '0', '1');
INSERT INTO `lk_airport_inter_city` VALUES ('405', '哈博罗内', 'GBE', '0', '4');
INSERT INTO `lk_airport_inter_city` VALUES ('373', '明尼阿波利斯', 'MSP', '0', '3');
INSERT INTO `lk_airport_inter_city` VALUES ('383', '波特兰(美国)', 'PDX', '0', '3');
INSERT INTO `lk_airport_inter_city` VALUES ('398', '阿尔及尔', 'ALG', '0', '4');
INSERT INTO `lk_airport_inter_city` VALUES ('391', '拉各斯', 'LOS', '0', '4');
INSERT INTO `lk_airport_inter_city` VALUES ('325', '孟买', 'BOM', '0', '1');
INSERT INTO `lk_airport_inter_city` VALUES ('384', '曼彻斯特(美国)', 'MHT', '0', '3');
INSERT INTO `lk_airport_inter_city` VALUES ('334', '慕尼黑', 'MUC', '0', '2');
INSERT INTO `lk_airport_inter_city` VALUES ('369', '蒙特利尔', 'YMQ', '0', '3');
INSERT INTO `lk_airport_inter_city` VALUES ('304', '吉隆坡', 'KUL', '1', '1');
INSERT INTO `lk_airport_inter_city` VALUES ('425', '达尔文', 'DRW', '0', '5');
INSERT INTO `lk_airport_inter_city` VALUES ('336', '柏林', 'BER', '0', '2');
INSERT INTO `lk_airport_inter_city` VALUES ('376', '渥太华', 'YOW', '0', '3');
INSERT INTO `lk_airport_inter_city` VALUES ('413', '墨尔本(澳大利亚)', 'MEL', '0', '5');
INSERT INTO `lk_airport_inter_city` VALUES ('411', '卢克索', 'LXR', '0', '4');
INSERT INTO `lk_airport_inter_city` VALUES ('305', '大阪', 'OSA', '1', '1');
INSERT INTO `lk_airport_inter_city` VALUES ('364', '华盛顿', 'WAS', '0', '3');
INSERT INTO `lk_airport_inter_city` VALUES ('414', '奥克兰(新西兰)', 'AKL', '0', '5');
INSERT INTO `lk_airport_inter_city` VALUES ('357', '纽约', 'NYC', '1', '3');
INSERT INTO `lk_airport_inter_city` VALUES ('352', '基辅', 'IEV', '0', '2');
INSERT INTO `lk_airport_inter_city` VALUES ('417', '珀斯', 'PER', '0', '5');
INSERT INTO `lk_airport_inter_city` VALUES ('339', '苏黎世', 'ZRH', '0', '2');
INSERT INTO `lk_airport_inter_city` VALUES ('372', '达拉斯', 'DFW', '0', '3');
INSERT INTO `lk_airport_inter_city` VALUES ('321', '济州岛', 'CJU', '0', '1');
INSERT INTO `lk_airport_inter_city` VALUES ('375', '圣保罗(巴西)', 'SAO', '0', '3');
INSERT INTO `lk_airport_inter_city` VALUES ('319', '金边', 'PNH', '0', '1');
INSERT INTO `lk_airport_inter_city` VALUES ('355', '布拉格', 'MIL', '0', '2');
INSERT INTO `lk_airport_inter_city` VALUES ('390', '内罗毕', 'NBO', '0', '4');
INSERT INTO `lk_airport_inter_city` VALUES ('348', '纽卡斯尔(英国)', 'NCL', '0', '2');
INSERT INTO `lk_airport_inter_city` VALUES ('404', '雅温得', 'YAO', '0', '4');
INSERT INTO `lk_airport_inter_city` VALUES ('350', '圣彼得堡', 'LED', '0', '2');
INSERT INTO `lk_airport_inter_city` VALUES ('356', '杜塞尔多夫', 'DUS', '0', '2');
INSERT INTO `lk_airport_inter_city` VALUES ('394', '达累斯萨拉姆', 'DAR', '0', '4');
INSERT INTO `lk_airport_inter_city` VALUES ('424', '霍巴特', 'HBA', '0', '5');
INSERT INTO `lk_airport_inter_city` VALUES ('374', '费城', 'PHL', '0', '3');
INSERT INTO `lk_airport_inter_city` VALUES ('415', '布里斯班', 'BNE', '0', '5');
INSERT INTO `lk_airport_inter_city` VALUES ('423', '帕皮堤', 'PPT', '0', '5');
INSERT INTO `lk_airport_inter_city` VALUES ('421', '楠迪', 'NAN', '0', '5');
INSERT INTO `lk_airport_inter_city` VALUES ('401', '突尼斯', 'TUN', '0', '4');
INSERT INTO `lk_airport_inter_city` VALUES ('313', '马累', 'MLE', '0', '1');
INSERT INTO `lk_airport_inter_city` VALUES ('382', '奥兰多', 'ORL', '0', '3');

如果觉得不太适合自己的项目也有采集的全球机场数据txt版,附上下载链接(这里要感谢车爷的友情采集)

\n换行 \t分隔数据,用php下面这段代码就可以整理好数据,然后转换成自己的mysql数据结构插入数据库即可

$file = file_get_contents('./data.txt');
$lines = explode("\n", $file);
foreach ($lines as $key => $value) {
    $data[] = explode("\t", $value);
}

发表评论

电子邮件地址不会被公开。 必填项已用*标注