py 连接mysql

pip install pymysql

import pymysql

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

try:
    # 执行SQL语句
    with connection.cursor() as cursor:
        sql = "SELECT * FROM your_table"
        cursor.execute(sql)
        results = cursor.fetchall()
        for row in results:
            # 处理查询结果
            print(row)
finally:
    # 关闭数据库连接
    connection.close()