Member Avatar

Hi,

I have imported .csv file and column is appearing as Col 1, Col 2...
and the data I want as a column name is appearing as a first row.
How do I convert my first row into column name in phpmyadmin.
Thanks in advance

Edited by code_rum
  • 2 Contributors
  • forum 6 Replies
  • 579 Views
  • 15 Hours Discussion Span
  • comment Latest Post Latest Post by code_rum

Recommended Answers

Answered by pritaeas 2,015 in a post from

There should be a checkmark to identify the first row as the column names.

Jump to Post
Answered by pritaeas 2,015 in a post from

All available columns need to have a valid name.

Jump to Post

All 6 Replies

Member Avatar

There should be a checkmark to identify the first row as the column names.

Member Avatar

I did that but it gives me an error

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
Edited by code_rum
Member Avatar

Can you show the first line with the column names? It may be a problem with spaces, or quotes.

Member Avatar

Yes i do have columns with no data i.e spaces.
So is it possible anyway??

Member Avatar

All available columns need to have a valid name.

Member Avatar

Thanks pritaeas

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.

Sign Up — It's Free!