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

Import to new table

Kembreg posted 2 years ago in Import/Export
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
ansgar posted 2 years ago
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?
Kembreg posted 2 years ago
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?
ansgar posted 2 years ago
This forum does not support file attachments. But you could link it somewhere else, or just describe it.
Ash501 posted 2 years ago
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

BubikolRamios posted 2 years ago
idea:
1. input table name - default = file name
2. autocount num of cols
2. create all columns of type varchar
4. import
ansgar posted 2 years ago
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.