Trying to input variable into an already created row in sql database [duplicate]

Question

I am trying to input the score to a quiz into a database in which the user already has an account.

I am getting an error saying - "sqlite3.OperationalError: near "WHERE": syntax error"

conn.execute("INSERT INTO PlH WHERE username == (?) VALUES (?)",(username,score))
conn.commit()

The column names in the sql database are named 'PlH' and 'username' and the variables are 'score' and 'username' respectively

To change a value of an already created row, use UPDATE PlH SET score = ? WHERE username = ?. Don't use ==, use = in SQL. See SQLite Update. — Olivier Jacot-Descombes
– Olivier Jacot-Descombes, Commented Sep 4, 2021 at 16:40

asd-tm · Accepted Answer · 2021-09-04 16:50:22Z

0

If I understood your question properly, you want to refresh the record in the table not to insert a new one. For this purpose you need to use UPDATE statement instead. WHERE clause of the script will be used to identify the required row (sometimes used for the list of rows updated simultaneously). SET clause wil specify the list of fields and new values to be assigned. Read SQLite documentation for the syntaxis.

edited Sep 4, 2021 at 16:50

answered Sep 4, 2021 at 16:39

asd-tm

5,2652 gold badges29 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Trying to input variable into an already created row in sql database [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related