I remeber I requested a while ago for feature , to be able to select which columns from csv to import - I guess that and ability to edit data on joined queryies are only reason I have to have toad for mysql instaled.
Is that any near - feature to be able to select which columns from csv to import ?
select columns for import
CSV import offers the selection of columns - Yes it does, table columns.
But want to be able to select columns from csv file to. Say I have table with 3 columns and csv with 5, and want to fit columns 1,3,5 into that table. See what I mean ?
As I suggested (on this forum), csv import should have one extra optional input, wehere we could input (regarding upper sample) '1,3,5' or '1,5,3' or whatever needed.
But want to be able to select columns from csv file to. Say I have table with 3 columns and csv with 5, and want to fit columns 1,3,5 into that table. See what I mean ?
As I suggested (on this forum), csv import should have one extra optional input, wehere we could input (regarding upper sample) '1,3,5' or '1,5,3' or whatever needed.
That stuff should go into issue #1379.
Please login to leave a reply, or register at first.