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
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
Jump to PostThere should be a checkmark to identify the first row as the column names.
Jump to PostAll available columns need to have a valid name.
There should be a checkmark to identify the first row as the column names.
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
Can you show the first line with the column names? It may be a problem with spaces, or quotes.
Yes i do have columns with no data i.e spaces.
So is it possible anyway??
All available columns need to have a valid name.
Thanks pritaeas
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.
You're trying to visit a URL that doesn't currently exist on the web. Most likely, a member posted a link a long time ago to a web page that has since been removed. It's also possible that there was a typo when posting the URL. We redirect you to this notice instead of stripping out the link to preserve the integrity of the post.