Import csv
| User, date | Message |
|---|---|
|
Written by BubikolRamios
2 years ago Category: Feature discussion 273 posts since Thu, 14 Jan 10 |
Sometimes I would like HEIDI sql to be able to create table on the fly. That is, if I feed .csv file to it, that there would be option - auto create table where you would tell new table name, columns would be by default named forinstance col1,col2,... |
|
Written by ansgar
2 years ago 3955 posts since Fri, 07 Apr 06 |
Table creation is a complex task, which you can see in the table designer. Doing that "on the fly" would hide tons of settings you have, starting with column types, ending with foreign keys. |
|
Written by BubikolRamios
2 years ago 273 posts since Thu, 14 Jan 10 |
I ment default type for colmuns varchar, and the table would be temporary, no indexes, ... Reason, forinstance , to remove/ignore one or several not important colums, which is easy done with sql, and hard with anything else. |
|
Written by BubikolRamios
2 years ago 273 posts since Thu, 14 Jan 10 |
Or, another way to make it happen: Adding option to choose which columns to import. Heidi sql could show how many are there in .csv, from which we would be able to pick which. Like 3 of them if dest table has 3 target columns. |
|
Written by ansgar
2 years ago 3955 posts since Fri, 07 Apr 06 |
That's basically what issue #1379 already asks for. |
|
Written by BubikolRamios
2 years ago 273 posts since Thu, 14 Jan 10 |
may I suggest that you put under: "ignore first 0 lines" something like "ignore columns: 1,4,7" that would be peace of cake implementing, I presume. |
|
Please login to leave a reply, or register at first. |