Newbie Problem, but I've tried creating a new table and importing the csv to that then updating, but I have been having trouble with that, any guidance would be greatly appreciated.
I have a csv file that contains about 1500 entries, with an "ID" column and an "Unit" column. I am trying to figure out the best way to update, in my mySQL workbench table, the "unit" of only the IDs in my csv file.
id_inv unit 1, aaa 2, aaa 3, aaa 5, aaa 10, aaa
id_inv unit ... other columns 1 bbb 2 bbb 3 bbb 4 bbb 5 bbb 6 bbb 7 bbb 8 bbb 9 bbb 10 bbb