IP2Location™ Region Multilingual Database

"country_alpha2_code","country_numeric_code","country_name","region_code","region_name","lang_code","lang_name","lang_region_name"
"AD","020","Andorra","AD-07","Andorra la Vella","EN","ENGLISH","Andorra la Vella"
"AD","020","Andorra","AD-02","Canillo","EN","ENGLISH","Canillo"
"AD","020","Andorra","AD-03","Encamp","EN","ENGLISH","Encamp"
"AD","020","Andorra","AD-08","Escaldes-Engordany","EN","ENGLISH","Escaldes-Engordany"
"AD","020","Andorra","AD-04","La Massana","EN","ENGLISH","La Massana"

CREATE TABLE `ip2location_region_multilingual`(
	`country_alpha2_code` VARCHAR(2),
	`country_numeric_code` VARCHAR(3),
	`country_name` VARCHAR(64),
	`region_code` VARCHAR(10),
	`region_name` VARCHAR(128),
	`lang_code` VARCHAR(5),
	`lang_name` VARCHAR(50),
	`lang_region_name` VARCHAR(200),
    PRIMARY KEY (`country_alpha2_code`,`region_name`)
) CHARSET=utf8 COLLATE=utf8_bin;

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