myconn rollback( myconn close(fig output of create table insert operation the insert into statement is used to add record to the table in pythonwe can mention the format specifier (%sin place of values we provide the actual values in the form of tuple in the execute(method of the cursor consider the following example import mysql connector #create the connection object myconn mysql connector connect(host "localhost"user "root", asswd "google",database "pythondb" #creating the cursor object cur myconn cursor( sql "insert into employee(nameidsalarydept_idbranch_namev alues (% % % % % ) #the row values are provided in the form of tuple