Making first row as column name in phpmyadmin

Question

0

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

mysql php phpmyadmin

Edited 4 Years Ago by code_rum

2

Contributors

6

Replies

20

Views

4 Years

Discussion Span

4 Years Ago

Last Post by code_rum

This Question has been Answered

1

All available columns need to have a valid name.

mysql php phpmyadmin

pritaeas 1,949 · Answer 1 · 2013-06-10T16:40:22+00:00

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

code_rum 8 · Answer 2 · 2013-06-10T16:42:31+00:00

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

pritaeas 1,949 · Answer 3 · 2013-06-10T17:05:25+00:00

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

code_rum 8 · Answer 4 · 2013-06-10T17:16:42+00:00

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

code_rum 8 · Answer 5 · 2013-06-11T07:59:24+00:00

Thanks pritaeas