Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need help importing CSV file into mysql database

Status
Not open for further replies.
unomateo

unomateo

IS-IT--Management
May 9, 2006
38
US
Hi,

I have a csv file with over 300 columns. I do not want to manually create the table with that many columns, then import the csv file to fill the data.

Is there a way to import the csv file and have the first row in the file create the table column names?
 
Sort by date Sort by votes
No. However, you could use a text editor (or program code) to assemble the CREATE TABLE statement from the first row of the file.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

E
  • Locked
  • Question
MySQL calculator tools
Replies
0
Views
230
EdZzy
E
lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
450
lupidol
lupidol
lupidol
  • Locked
  • Question
mysql cannot add rows with "UNION" 1
Replies
5
Views
407
Chris Miller
Chris Miller
dylim
  • Locked
  • Question
Why MySQL 5.7 is still getting updates
Replies
3
Views
339
spamjim
spamjim
EdLentz
  • Locked
  • Question
Need to compare two tables and list the differences
Replies
3
Views
404
EdLentz
EdLentz

Part and Inventory Search

Sponsor

Back
Top