创建动态表-3列乘N行？

CREATE TABLE dynamic_table (
    column1 datatype,
    column2 datatype,
    column3 datatype
);

import mysql.connector

# 连接到数据库
conn = mysql.connector.connect(
    host="localhost",
    user="username",
    password="password",
    database="database_name"
)

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

# 循环插入数据
N = 10  # 行数
for i in range(N):
    # 生成插入语句
    insert_query = "INSERT INTO dynamic_table (column1, column2, column3) VALUES (%s, %s, %s)"
    values = (value1, value2, value3)  # 根据实际需求设置插入的值
    cursor.execute(insert_query, values)

# 提交事务
conn.commit()

# 关闭游标和连接
cursor.close()
conn.close()