Sql将python元组合并到键上的数据库中？

import pymysql

# 连接数据库
conn = pymysql.connect(host='localhost', user='root', password='password', database='mydb')
cursor = conn.cursor()

# 创建表
create_table_query = '''
CREATE TABLE IF NOT EXISTS mytable (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(255),
    age INT
)
'''
cursor.execute(create_table_query)

# 定义要插入的数据
data = [
    ('John', 25),
    ('Alice', 30),
    ('Bob', 35)
]

# 插入数据
insert_query = 'INSERT INTO mytable (name, age) VALUES (%s, %s)'
cursor.executemany(insert_query, data)

# 提交事务
conn.commit()

# 关闭连接
cursor.close()
conn.close()

update_query = 'UPDATE mytable SET age = %s WHERE name = %s'
cursor.execute(update_query, (26, 'John'))
conn.commit()