IP2Location™气象站代码数据库
示例数据库
“天气站代码”,“wooid”,“icao_code”,“iata_code“ “AAXX0001”,“56069”,“LFVP”,“FVP” “AAXX0002”,“12510298”,“LFVP”,“FVP” “ACXX0001”,“23397089”,“LFVP”,“FVP” “ACXX0002”,“1533”,“LFVP”,“FVP” “AEXX0001”,“1940330”,“LIBL”,“”
MySQL语句
创建表格`ip2location_weather_station_code`( `weather_station_code`VARCHAR(10), `悲哀`INT(10), `icao_code`VARCHAR(4), `iata_code`VARCHAR(10), 索引`idx_country_alpha2_code`(`weather_station_code`) )ENGINE=MyISAM默认字符集=utf8 COLLATE=utf8_bin; 本地加载数据 充气IP2位置-密封-站-代码。 CSV'到表`ip2location_weather_station_code` 字段以“,”结尾 由“”封装 线路以“\r\n”IGNORE 1线路终止;