Import to new table

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

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?

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?

This forum does not support file attachments. But you could link it somewhere else, or just describe it.

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

idea:
1. input table name - default = file name
2. autocount num of cols
2. create all columns of type varchar
4. import

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.

What happened to this idea?

I like it.