Importing CSV to the MySQL database by inserting only the first row


I ran below SQL query against my MySQL database:

load data local infile '/tmp/ad_packs.csv'
into table ad_packs
fields terminated by ','
enclosed by '"'
lines terminated by '\n'

This seems to insert only one row and I already checked the csv and it has heading so it only inserts the first row which is the header.

Is there a reason why?

Are you sure sure your lines are terminated by "\n"? Try "\r\n";