Hi,

I am trying to import a CSV file but my code breaks around the 'r\n' can any one help me work out how to resolve this?
Code Python:
cursor.execute ("LOAD DATA INFILE '/tmp/trains.csv' INTO TABLE trains FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'IGNORE 1 LINES;")