Parameters are not saved in sqlite3, what should I do?

Question

Python

Parameters are not saved in sqlite3, I'm doing everything right. HELP!

db = sqlite3.connect('database.db')
sql = db.cursor()

sql.execute("""CREATE TABLE IF NOT EXISTS users(
  id INT
  balance BIGINT
  name TEXT)""")

db.commit()
user = vk_session.method("users.get", {"user_ids": id})
name = user[0]['first_name']
sql.execute(f"INSERT INTO users VALUES (?, ?, ?)", (id, 0, name))
db.commit()

error occurs: sqlite3.OperationalError: table users has 1 columns but 3 values ​​were supplied

Answer 1

Recreate database.db.
Something tells me that you have an old structure there, where there is only one column.
And yes, it doesn't hurt to create another column for the PRIMARY KEY.

Answer 2

sql.execute("""CREATE TABLE IF NOT EXISTS users(
  id INT
  balance BIGINT
  name TEXT)""")

This query requires commas:

CREATE TABLE IF NOT EXISTS users(
  id INT,
  balance BIGINT,
  name TEXT)

And so, yes, because of IF NOT EXISTS, it seems that the table with the old structure remains and is not recreated