Mysql LOAD DATA INFILE doesnt work properly

Mysql LOAD DATA INFILE doesnt work properly

This is my mysql query: LOAD DATA LOCAL INFILE 'E:\c.csv'
INTO TABLE messages
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\r\n'
(idR, idS, nameS,message,readd);
and my .csv file: 7,998,mehman,hello,5 and 8,998,mehm,hello,5 2 rows
everything is fine except it writes 0 instead of 7 in the first row and
why there is no difference when changing \r\n to \n? thanks in advance!