python怎样使用mysql

pip install mysql-connector-python
# 或
pip install pymysql

import mysql.connector

# 连接数据库
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)

# 创建游标对象
mycursor = mydb.cursor()

# 执行 SQL 查询
mycursor.execute("SELECT * FROM yourtable")

# 获取查询结果
myresult = mycursor.fetchall()

for x in myresult:
  print(x)

import pymysql

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

# 创建游标对象
with conn.cursor() as cursor:
    # 执行 SQL 查询
    cursor.execute("SELECT * FROM yourtable")
    # 获取查询结果
    result = cursor.fetchall()
    for row in result:
        print(row)

# 关闭连接
conn.close()