Y
Y
yeahxd2021-06-03 00:41:56
Python
yeahxd, 2021-06-03 00:41:56

How to replace value in sqlite3?

There is a database

cursor.execute("""CREATE TABLE IF NOT EXISTS users(
        status TEXT,
        money BIGINT
    )""")
    connection.commit()


In this database, status = hello
, I want to change hello to bye, but I don't know how

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
SergMalax, 2021-06-03
@yeahxd

cursor.exesute('UPDATE SET status="Ваше значение" '
db.commit()

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question