mysql 批量建表脚本

import mysql.connector

# 数据库连接配置
config = {
    'user': 'your_username',
    'password': 'your_password',
    'host': 'localhost',
    'database': 'your_database'
}

# 表结构定义
tables = {
    'table1': """
    CREATE TABLE table1 (
        id INT AUTO_INCREMENT PRIMARY KEY,
        name VARCHAR(255) NOT NULL
    )
    """,
    'table2': """
    CREATE TABLE table2 (
        id INT AUTO_INCREMENT PRIMARY KEY,
        age INT NOT NULL
    )
    """
}

# 连接到数据库
cnx = mysql.connector.connect(**config)
cursor = cnx.cursor()

# 创建表
for table_name, table_sql in tables.items():
    try:
        cursor.execute(table_sql)
        print(f"Table {table_name} created successfully.")
    except mysql.connector.Error as err:
        print(f"Failed creating table {table_name}: {err}")

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