CSV file import MySQL do I need to create a new table? workaround

CSV file import MySQL do I need to create a new table?
I have a CSV file that needs to be imported into MySQL, whether it is necessary to build a table first, and then in the new field, I have tried to build a table, also built a field, and then import with phpMyAdmin, and then error, the message is Invalid field count in CSV input on line 1.

Do not know why ~ ask Daniel to answer me this just started, thank you


Oops, can not insert attachment picture, just can have outside chain ... Not a pit daddy?

------Solution--------------------
$con = mysql_connect ("localhost", "Peter", "abc123");
if (! $con)
{
Die (' Could not connect: '. Mysql_error ());
}

Create Database
if (mysql_query ("CREATE DATABASE my_db", $con))
{
echo "Database created";
}
Else
{
echo "Error Creating Database:". Mysql_error ();
}

Create table
mysql_select_db ("my_db", $con);
mysql_query ("SET NAMES UTF8");
$sql = "CREATE Table table name
(
PartyID varchar (60),
Full NAME varchar (100),
Local NAME varchar (100),
... all columns in the//CVS
)";

Execute Query
mysql_query ($sql, $con);

Mysql_close ($con);
?>
------Solution--------------------
Invalid field count in CSV input on line 1.
The CSV input field number on line 1 is inefficient.

Confirm that the data type of the column is correct!
The first row (header row) should be skipped when importing

