How to Load Data from Text File in MySQL?
- by Taz
I have this file availableHere Fields are separated by space and newline starts at new line. I am using this command to load data
mysql> LOAD DATA LOCAL INFILE 'C:\\Documents and Settings\\Scan\\My Documents\\Downloads\\images_en.nt\\Sample4.txt' INTO TABLE NER.Images FIELDS TERMINATED BY' ' LINES TERMINATED BY '\n';'
Only one row is loaded and if I execute again No row is loaded. Where is the problem?
Data can be modified to reformat if required.