在python中将数据输入SQL表？

import pymysql

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

# 创建表（如果表不存在）
create_table_sql = '''
CREATE TABLE IF NOT EXISTS mytable (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(255),
    age INT
)
'''
cursor.execute(create_table_sql)

# 插入数据
data = [
    ('Alice', 25),
    ('Bob', 30),
    ('Charlie', 35)
]
insert_sql = 'INSERT INTO mytable (name, age) VALUES (%s, %s)'
cursor.executemany(insert_sql, data)

# 提交事务
conn.commit()

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