Comparing two csv files and changing values ​​by condition?

Question

linux

There are two csv files.
1st:

Наименование;Артикул;Код;Остаток
Уголь;01ug;00000102;0
Дрова;DR;00000406;9
Торф;TF;00000803;1
Газ;G1Z;00000412;5

2nd

Код;Остаток
00000406;15
00000803;6

Can you please tell me the options on how to overwrite the values ​​of the "residual" column in the first file, taking them from the second. It is even possible by generating a third file, consisting only of those "Codes", the rest of which is updated.

Answer 1

I would run through mysql
www.internet-technologies.ru/articles/article_1852.html
www.tech-recipes.com/rx/1475/save-mysql-query-resu...