dimanche 29 mars 2015

Why is this sqlite3 UPDATE giving a syntax error?

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