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.
CSV File
id_inv unit
1, aaa
2, aaa
3, aaa
5, aaa
10, aaa
DB Table
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