I have a function that drops some tables and reinitializes a new set which are working fine, then when it updates the existing table with the following:
self.cursor.execute('''UPDATE beers1 SET (beer_name, og, fg, beer_desc, ibu, glass_type, keg_size)
VALUES (?,?,?,?,?,?,?) where id=1''',("Beer", 1, 1, "Delicious!", 0, "Pint Glass", 640))
Which then gives me:
OperationalError: near "(": syntax error
Any insight would be incredibly helpful. Thanks!
Aucun commentaire:
Enregistrer un commentaire