How to find all rows with values ​​0 and add 1 to them?

Question

Python

There is a database, it has the following columns:
id - user id
amount - some number
How to find all users with amount = 0, and add 1

Answer 1

execute('UPDATE table_name SET amount=1 WHERE amount=0')