https://dev.maxmind.com/geoip/importing-databases/mysql/#test-our-table-by-querying-it

geoip2-csv-converter\

https://blog.csdn.net/gitblog_00125/article/details/141877374

pyhton查询: https://blog.51cto.com/u_16175439/8381391

load data infile 'C:\\MySQL\\MySQL Server 8.0\\Uploads\\GeoIP2-City-Blocks-IPv4-Hex.csv'

into table geoip2_network

fields terminated by ',' enclosed by '"' lines terminated by '\n' ignore 1 rows

(@network_start, @network_end, @geoname_id, @registered_country_geoname_id, @represented_country_geoname_id,

 @is_anonymous_proxy, @is_satellite_provider, @postal_code, @latitude, @longitude, @accuracy_radius, @is_anycast)

set network_start = unhex(@network_start),

    network_end = unhex(@network_end),

    geoname_id = nullif(@geoname_id, ''),

    registered_country_geoname_id = nullif(@registered_country_geoname_id, ''),

    represented_country_geoname_id = nullif(@represented_country_geoname_id, ''),

    is_anonymous_proxy = nullif(@is_anonymous_proxy, ''),

    is_satellite_provider = nullif(@is_satellite_provider, ''),

    postal_code = nullif(@postal_code, ''),

    latitude = nullif(@latitude, ''),

    longitude = nullif(@longitude, ''),

    accuracy_radius = nullif(@accuracy_radius, ''),

    is_anycast = nullif(@is_anycast, '');

load data infile 'C:\\MySQL\\MySQL Server 8.0\\Uploads\\GeoLite2-Country-Locations-en.csv'

into table geoip2_location

fields terminated by ',' enclosed by '"' lines terminated by '\r\n' ignore 1 rows (

  @geoname_id, @locale_code, @continent_code, @continent_name,

  @country_iso_code, @country_name, @subdivision_1_iso_code, @subdivision_1_name,

  @subdivision_2_iso_code, @subdivision_2_name, @city_name, @metro_code, @time_zone,

  @is_in_european_union

)

set 

geoname_id = nullif(@geoname_id, ''),

locale_code= nullif(@locale_code, ''),

continent_code= nullif(@continent_code, ''),

continent_name= nullif(@continent_name, ''),

country_iso_code = nullif(@country_iso_code, ''),

    country_name = nullif(@country_name, ''),

    subdivision_1_iso_code = nullif(@subdivision_1_iso_code, ''),

    subdivision_1_name = nullif(@subdivision_1_name, ''),

    subdivision_2_iso_code = nullif(@subdivision_2_iso_code, ''),

    subdivision_2_name = nullif(@subdivision_2_name, ''),

    city_name = nullif(@city_name, ''),

    metro_code = nullif(@metro_code, ''),

    time_zone = nullif(@time_zone, ''),

is_in_european_union= nullif(@is_in_european_union, '');

红色是修改后的，网站上的有问题。