在Windows中将MySQL与Python集成

pip install mysql-connector-python

import mysql.connector

cnx = mysql.connector.connect(
    host="localhost",
    user="your_username",
    password="your_password",
    database="your_database"
)

cursor = cnx.cursor()

query = "SELECT * FROM your_table"
cursor.execute(query)

for row in cursor:
    print(row)

cursor.close()
cnx.close()