python安装mysql数据库

pip install mysql-connector-python

pip install PyMySQL

import pymysql

# 连接数据库
conn = pymysql.connect(
    host='localhost',
    user='your_username',
    password='your_password',
    db='your_database',
    charset='utf8mb4',
    cursorclass=pymysql.cursors.DictCursor
)

try:
    with conn.cursor() as cursor:
        # 创建表
        sql = "CREATE TABLE IF NOT EXISTS `users` (`id` INT AUTO_INCREMENT PRIMARY KEY, `name` VARCHAR(255), `email` VARCHAR(255))"
        cursor.execute(sql)
        
        # 插入数据
        sql = "INSERT INTO `users` (`name`, `email`) VALUES (%s, %s)"
        cursor.execute(sql, ('Alice', 'alice@example.com'))
        
        # 提交事务
        conn.commit()
        
        # 查询数据
        sql = "SELECT * FROM `users`"
        cursor.execute(sql)
        result = cursor.fetchall()
        print(result)
finally:
    conn.close()