'Importing csv file to a table in the database also inserts the column names as values

I'm trying to insert these data to my table in the MySQL database using CSV import.

|id |employee_number    |name   |role|
     123456              Paul    Admin

But when I import it, I get two rows on my table like this

 |id    |employee_number    |name   |role|
  1       0                  name    role
  2       123456             Paul    Admin

My CSV file is structured simply like this,

|id |employee_number    |name   |role|
     123456              Paul    Admin

I import the CSV using phpMyAdmin with default import options, I'm not changing anything in the import options. Can anyone help please why am I getting an additional row of data?

mysqlcsvphpmyadmin


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions