Oct-19-2020, 07:20 AM
(This post was last modified: Oct-19-2020, 07:35 AM by JellyCreeper6.)
Any help is appreciated.
Now I want to update the
But
Table name - Encounters name |encounters|PreEnc|PostEnc| 'Name1'|0 |20 |0 |the values for
encounters
, PreEnc
, PostEnc
are default to 0.Now I want to update the
PostEnc
with a number.import sqlite3 conn = sqlite3.connect('Encounters.db') c = conn.cursor() c.execute("UPDATE Encounters SET PostEnc=? WHERE name=?", (sumlst,user)) conn.commit() for row in c.execute("SELECT PostEnc FROM Encounters WHERE name = ?", [user]): print(row) for row in c.execute("SELECT PreEnc FROM Encounters WHERE name = ?", [user]): print(row)
sumlst = 12345
user = 'Name'
But
PostEnc
does not get updated and I get nothing with the print(row)