Update Query is used to modify records from existing table or database using python interface.
We can modify records using different conditions as per need.
Syntax:
cur.execute("Update tablename set column_name = value where condition" )
Here,
set : is used to assign updated or modified value to existing column.
where : is used to give desired condition
Note:
Before using update query it is mandatory to use or create database and related table. Also values must be present to be modified from table else no rows will be affected.