Read Data from .txt file in sql
LOAD DATA LOCAL INFILE ‘C:\\[your folder path to the data file]\\GEODATASOURCE-WORLD-MAJOR-CITIES-SAMPLES.TXT’
INTO TABLE `countrystatecitydb`.`countrystatecity`
CHARACTER SET utf8
FIELDS
TERMINATED BY ‘\t’0
LINES
TERMINATED BY ‘\r\n’;
