IP2Location™ Continent Multilingual Database

MySQL Statement

CREATE TABLE `ip2location_continent_multilingual`(
	`lang` VARCHAR(5),
	`country_alpha2_code` CHAR(2),
	`continent` VARCHAR(50),
	INDEX `idx_lang` (`lang`),
	INDEX `idx_country_alpha2_code` (`country_alpha2_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.