I have a CSV file that has 2 columns
I have a table in my database that has the same columns + some extra columns.
Now I would like to update my db table using that csv file. I mean like this
UPDATE `mytable` SET `email` = 'csvemail' WHERE `name` = 'csvname'
Can someone help me to do that from my ubuntu terminal?