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

Edited by code_rum

2
Contributors
6
Replies
20
Views
4 Years
Discussion Span
Last Post by code_rum
0

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

0

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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.