distal-attribute
distal-attribute
distal-attribute
distal-attribute

Import to new table

User, date Message
Written by Kembreg
2 years 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
2 years ago
4932 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
2 years 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
2 years ago
4932 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
2 years 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 producthappy
Written by BubikolRamios
2 years ago
327 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
2 years ago
4932 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.