python import mysql.connector

db = mysql.connector.connect( host="localhost", user="yourusername", passwd="yourpassword", database="testdb" )

mycursor = db.cursor

mycursor.execute

mycursor.execute, address VARCHAR)")

sql = "INSERT INTO customers VALUES " val = mycursor.execute db.commit print

mycursor.execute myresult = mycursor.fetchall for x in myresult: print

sql = "UPDATE customers SET address = %s WHERE name = %s" val = mycursor.execute db.commit print affected")

mycursor.close db.close