脚本初始化mysql

import mysql.connector

# 连接到MySQL数据库
config = {
    'user': 'your_username',
    'password': 'your_password',
    'host': 'localhost',
    'database': 'your_database'
}
cnx = mysql.connector.connect(**config)
cursor = cnx.cursor()

# 创建表
create_table_query = """
CREATE TABLE IF NOT EXISTS users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    email VARCHAR(255) NOT NULL
)
"""
cursor.execute(create_table_query)

# 插入初始化数据
insert_data_query = """
INSERT INTO users (name, email) VALUES
('Alice', 'alice@example.com'),
('Bob', 'bob@example.com')
"""
cursor.execute(insert_data_query)

# 提交更改并关闭连接
cnx.commit()
cursor.close()
cnx.close()