phpMyAdmin导入CSV文件出现:
Invalid field count in csv input on line 1
To solve this I had to do the following:
1, Import
2, Browse for your csv file.
3, Select CSV using LOAD DATA (rather than just CSV)
4, Change “Fields terminated by” from “;” to “,”
5, Make sure “Use LOCAL keyword” is selected.
6, Click “Go”