How to parse csv file and update records in database

I have csv file like mentioned below

store-day.csv
----------------------
store, business_date
101,23/06/2021
102,01/07/2021

I want to loop through records from csv file and update table
update store_day set staus='W' where store=, date=
how to achieve this in shell script?

See:

1 Like