Import to new table
| User, date | Message |
|---|---|
|
Written by Kembreg
11 months ago Category: Import/Export 19 posts since Tue, 22 Jun 10 |
Hi all. Maybe I'm missing something... If I have a CSV file, there must be a way to simply click "Upload to new table" and the table would create itself based on the headinings in the CSV. I would appreciate if someone could let me know how this is done in HeidiSQL. Thanks, David |
|
Written by ansgar
11 months ago 3949 posts since Fri, 07 Apr 06 |
No, you must create the table before you can import data. Database design is better done by people rather than by dumb import routines. On the other hand this sounds like a nice addition to the import dialog. I only have no clue how to implement the GUI for that feature. Any idea how that could look/work like? |
|
Written by Kembreg
11 months ago 19 posts since Tue, 22 Jun 10 |
Hi. I would like to importat a table with 75 columns. To create that manually would be a lot of work. I think it would be a good feature to be able to import to a new table automatically. How can I send you a jpg to show you a possible gui? |
|
Written by ansgar
11 months ago 3949 posts since Fri, 07 Apr 06 |
This forum does not support file attachments. But you could link it somewhere else, or just describe it. |
|
Written by Ash501
11 months ago 21 posts since Tue, 20 Mar 12 |
Perhaps the GUI could: 1st: Grab the NAME of Column from first row. Then.... (1) Offer options to Define DATA for each column: one at a time - later to be edited/finetunnig... -Primitive option (2) An auto analysis of DATA for each column could autoselect a working default.... -Need a programer that's also a magician!... :o Regards anse! -& thanks for a great product 
|
|
Written by BubikolRamios
10 months ago 273 posts since Thu, 14 Jan 10 |
idea: 1. input table name - default = file name 2. autocount num of cols 2. create all columns of type varchar 4. import |
|
Written by ansgar
10 months ago 3949 posts since Fri, 07 Apr 06 |
Reasonable idea I think. VARCHARs don't break any data if you have numbers or dates in it. Leaves the responsibility for finetuning table design to the user. |
|
Please login to leave a reply, or register at first. |