Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
mysql > LOAD DATA LOCAL INFILE 'FILE-PATH-TO\\IP2LOCATION-LITE-DB3DB5.CSV' INTO TABLE ip2location_db3
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\r\n' 
IGNORE 0 LINES (ip_from,ip_to,country_code,country_name,region_name,city_name,latitude,longitude);

...