Invalid field count in csv input on line 1
When importing CSV data into my MySQL database using PHPMyAdmin, I found following error: Invalid field count in csv input on line 1.
It’s odd since I’ve manually count field numbers and compared with column on my CSV files, they’re exactly match.
Then I found something strange. PHPMyAdmin is automatically use semicolon ( ; ) as field delimiter instead of comma ( , ). Quick fix for this problem is to change the delimiter symbol manually.
In the picture above, I replaced semicolon (rounded with blue circle) with comma and everything is alright.
