Read Data from .txt file in sql
1 min read
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’;... Read More
