Making first row as column name in phpmyadmin

[code_rum]

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

[pritaeas]

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

[code_rum]

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]

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

[code_rum]

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

[pritaeas]

All available columns need to have a valid name.

[code_rum]

Thanks pritaeas