Can I do that?

Question

Python

I have many columns in a table.
And in order not to write my own UPDATE for each, can I specify what exactly to update?

cur.execute(f"UPDATE users SET ? = ? WHERE user_id=? AND chat_id=?")
cur.commit()

And if I can’t, are there any other, more beautiful ways than stupidly copying?

Answer 1

You can try this, but it won't cut your code that much:
cur.execute(f"UPDATE users SET field1=?, field2=?, fieldN=? WHERE user_id=? AND chat_id=?")

Answer 2

nnikolyaa , try using executemany() or executescript() instead of execute ( )