Problems with Load Data Infile
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:
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?