Uploading CSV

[Peter Richards]

Sorry if this is a very basic question, but ....

I'm in the process of setting up a MySQL database and have a one line test entry.

When the database is running live I need to be able to sort by one of the columns (surname) so have been trying to see how I may do this.

I can export the database as a CSV file, which is then opened in a spreadsheet (Open Office Calc) where it may be sorted.

However, I am unable to import it back again as whatever I try I have the error message:

Invalid column count in CSV input on line 1.

Yet I have ten columns in both MySQL and the CSV file

The columns look like this:

"id" "username" "firstname" "surname" "password" "email" "active" "code" "role" "avatar"


When I export the file into OO Calc I use the | to separate the fields. I know I have to edit this out if uploading to a flat database, but what should I be doing to successfully import the CSV file into MySQL please? At present I have been changing the "Columns separated with:" field from a comma to the | separator and I've tried entering:

id,username,firstname,surname,password,email,active,code,role,avatar

in the Column names field, but it made no difference.