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;

Attribution is required by mentioning the use of this data as follows, "The IP geolocation data is provided by https://www.ip2location.com", on your webpage and in the documentation or advertising.

IP2Location™ and IP2Proxy™ are registered trademarks of HEXASOFT. All other trademarks are the properties of their respective owners.