Sql server

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’;

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.