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'
(company_name,pack_size,remaining,ad_pack_purchase_officer,advertising_contact_officer,updated_ad_pack,email,phone,website,note,organisation_id,categories,modified)

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";