quick fix | July 22nd, 2021
Invalid field count in csv input on line 1
I was trying to import a massive csv dataset into phpMyAdmin and it kept throwing error:Invalid field count in csv input on line 1
This was very annoying as it was all being done the way it always works for me!
To solve this I had to do the following:
- Browse for your csv file.
- Select CSV using LOAD DATA (rather than just CSV)
- Change “Fields terminated by” from “;” to “,”
- Make sure “Use LOCAL keyword” is selected.
- Click “Go”