070-8260-2526

ÆòÀÏ ¿ÀÀü 9½Ã ~ ¿ÀÈÄ 6½Ã
´ÜÀ§³óÇù

352-0331-1626-83

¿¹±ÝÁÖ:°­¸¸¼öÅ×Å©³ÝÄÚ¸®¾Æ


ÀÚÁÖ¹¯´Â Áú¹®
Ȩ > °í°´¼¾ÅÍ > ÀÚÁÖ¹¯´Â Áú¹®

Á¶È¸¼ö 6719
Áú¹® [¼­¹ö°ü¸®] mySQL¿¡ CSVÆÄÀϾ÷·Îµå½Ã ¿À·ù³ª´Â °æ¿ì
phpMyAdmin – 1Invalid field count in csv input on line
Published on April 9, 2010 by Andrew in CSV, error, phpMyAdmin
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:

Import
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¡±
Done!