IP2Location™ Continent Multilingual Database

Sample Database

"lang","country_alpha2_code","continent_code","continent"
"EN","AD","EU","Europe"
"EN","AE","AS","Asia"
"EN","AF","AS","Asia"
"EN","AG","NA","North America"
"EN","AI","NA","North America"

MySQL Statement

CREATE TABLE `ip2location_continent_multilingual`(
	`lang` VARCHAR(5),
	`country_alpha2_code` CHAR(2),
	`continent_code` CHAR(2),
	`continent` VARCHAR(50),
	INDEX `idx_lang` (`lang`),
	INDEX `idx_country_alpha2_code` (`country_alpha2_code`),
	INDEX `idx_continent_code` (`continent_code`),
	INDEX `idx_continent` (`continent`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

LOAD DATA LOCAL
INFILE 'IP2LOCATION-CONTINENT-MULTILINGUAL.CSV' INTO TABLE `ip2location_continent_multilingual`
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n' IGNORE 1 LINES;

This works is licensed under Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0).

It is free for personal or commercial use with attribution required by mentioning the use of this works as follows:
"This site or product includes IP2Location™ Continent Multilingual Database which available from https://www.ip2location.com."