Create columns in mysql from csv

Posted on 2012-08-31
Medium Priority
Last Modified: 2012-09-07
Is it possible to create columns in a table in mysql based on comma delimited information in another file?
Question by:Jonathan CMCH
LVL 25

Expert Comment

ID: 38354254
Do you mean
  - alter the table's structure based on the file; or to
  - add data into the table from the file?

Author Comment

by:Jonathan CMCH
ID: 38354626
I would be altering the table.  I know I'm going to be scoffed at but I'm created a table that will host archived data which will be categorized by several hundred columns.  I've read where users have created dummy columns to import the data, but I haven't read anything where columns were created based on information in the CSV file.

Hope that clears up the question.
LVL 21

Accepted Solution

K V earned 2000 total points
ID: 38362438
I think you need this to load csv data in to mysql.

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month16 days, 3 hours left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question