title: Invalid column count in CSV input on line 1 error (Already checked other questions)
body: <p>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 &quot;;&quot;, already changed it in phpmyadmin to &quot;Columns separated with ;&quot;, but I still got the same error. Can anyone help?</p>
  <p><img src="https://i.stack.imgur.com/FAA6Y.png" alt="table structure" /></p>
  <p><img src="https://i.stack.imgur.com/irjNj.png" alt="csv file" /></p>
  <p>edit: I'm using the &quot;Import&quot; option of phpMyAdmin to import my csv</p>
  <p><img src="https://i.stack.imgur.com/wzQIj.png" alt="importing csv" /></p>
  <p>edit2: So I decided to export my table to see how the csv was generated. It exports like this:
  &quot;1&quot;, &quot;1001&quot;
  &quot;2&quot;, &quot;1002&quot;
  Do you know why? or how can I create an csv file with the same format?
  <a href="https://i.stack.imgur.com/s9djs.png" rel="nofollow noreferrer">export table</a></p>