Question: So I've seen this question asked many times but I have not found an answer to my issue. I'm using phpmyadmin, I have 1 table with 2 columns and I have a .csv with 2 columns. My csv does not have headers and my columns are separated by ";", already changed it in phpmyadmin to "Columns separated with ;", but I still got the same error. Can anyone help?

![table structure](https://i.stack.imgur.com/FAA6Y.png)

![csv file](https://i.stack.imgur.com/irjNj.png)

edit: I'm using the "Import" option of phpMyAdmin to import my csv

![importing csv](https://i.stack.imgur.com/wzQIj.png)

edit2: So I decided to export my table to see how the csv was generated. It exports like this:
"1", "1001"
"2", "1002"
Do you know why? or how can I create an csv file with the same format?
[export table](https://i.stack.imgur.com/s9djs.png)

Answer: 
As it says in the manual

> 
> When importing data into a table from a CSV file where the table has an ‘auto\_increment’ field, make the ‘auto\_increment’ value for each record in the CSV field to be ‘0’ (zero). This allows the ‘auto\_increment’ field to populate correctly.
> 
> 
> 

see <https://docs.phpmyadmin.net/en/latest/import_export.html>
So, what worked for me was: I exported the table as an csv and worked over that. After I was done, I imported this modified csv and it worked. It must've been what [nbk](https://stackoverflow.com/users/5193536/nbk) said about termination, so I guess in a way that was the answer