Hello all,

I'm having trouble using LOAD DATA INFILE. It is only loading the first record.

My source file (a win32 txt file) has the following format:

1,1,James Begley,
2,1,Rhett Biglands,
3,1,Nathan Bock,
...

The command i'm using is:

LOAD DATA INFILE 'players.txt' INTO TABLE players FIELDS TERMINATED BY ',' LINES TERMINATED BY '/r/n' (idplayer, idsourceteam, playername)

However the above only inserts the first field. Why is that?

Thank you,
Marden Lee

Forgot I had this post here.
The problem was solved. It is obvious that I shouldn't have had the last comma on each line.

Also, '/r/n' doesn't need to be established as line terminator on win32 based text files. '/n' will suffice, contrary to what the documentation says.