mysql批量建表

import mysql.connector

# 连接数据库
db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

# 定义要创建的表结构
tables = [
    {
        "name": "table1",
        "columns": [
            ("id", "INT AUTO_INCREMENT PRIMARY KEY"),
            ("name", "VARCHAR(255) NOT NULL")
        ]
    },
    {
        "name": "table2",
        "columns": [
            ("id", "INT AUTO_INCREMENT PRIMARY KEY"),
            ("description", "TEXT")
        ]
    }
]

# 执行批量建表
for table in tables:
    columns_str = ", ".join(f"{col[0]} {col[1]}" for col in table["columns"])
    create_table_sql = f"CREATE TABLE {table['name']} ({columns_str})"
    cursor.execute(create_table_sql)

# 提交事务
db.commit()

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

SELECT COUNT(*) INTO @exists FROM information_schema.tables WHERE table_name = 'table1';
IF @exists = 0 THEN
    CREATE TABLE table1 (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255) NOT NULL);
END IF;

CREATE TABLE table1 (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255) NOT NULL) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;