写一个python连接mysql并向数据库中的表添加信息的代码

import mysql.connector

#连接mysql数据库
mydb = mysql.connector.connect(
host="localhost",
user="root",
password="password",
database="mydatabase"
)

#创建游标对象
mycursor = mydb.cursor()

#向表中添加信息
sql = "INSERT INTO customers (name, address) VALUES (%s, %s)"
val = ("John", "Highway 21")
mycursor.execute(sql, val)

#提交更改
mydb.commit()

print(mycursor.rowcount, "记录已插入。")