M
M
mshuribitov2021-03-14 16:04:24
Python
mshuribitov, 2021-03-14 16:04:24

How to make a replacement for all in SQLITE?

Hello, I need to change all values ​​in the database to 0

Example:
There is a command for the game that can be used only 10 times a day, and it is necessary that every other day all values ​​of 10 change to 0 back
sql.execute(f' UPDATE users SET use_comand = {0}')

Tried to enter an asterisk, no matter how everything worked out

Answer the question

In order to leave comments, you need to log in

1 answer(s)
O
o5a, 2021-03-14
@o5a

to set a value, you need to specify it without any curly braces
sql.execute('UPDATE users SET use_comand = 0')

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question