How to update the existing table data from a API result!

I have a api result which i stored in table 1(fields: code, rate), i have a another table called table 2 (name, code, rate, isOnline). i would like to update the table2 column ‘rate’ based on ‘code’ matching. could anyone explain me how can i do this?