How to change value in SQLite?

Question

Python

nickname = input('Введите ник: ')
user_login = int(1) #1 для примера

sql.execute(f'UPDATE users SET nick = {nickname} WHERE login = "{user_login}"')
db.commit()

Error occurs:
sqlite3.OperationalError: no such column: cucumber

Answer 1

Single quotes must be used. And here nick = {nickname}, and here login = "{user_login}"
But better, as said above:

sql.execute(f'UPDATE users SET nick = ? WHERE login = ?', (nickname, user_login))

Answer 2

Using string interpolation to generate sql query is a very bad idea.