How to Load Data from Text File in MySQL?
Posted
by Taz
on Stack Overflow
See other posts from Stack Overflow
or by Taz
Published on 2010-04-23T04:23:32Z
Indexed on
2010/04/23
4:33 UTC
Read the original article
Hit count: 317
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.
© Stack Overflow or respective owner