python 连接mysql方法

pip install mysql-connector-python

import mysql.connector

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

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

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

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

for x in myresult:
  print(x)

pip install pymysql

import pymysql

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

try:
    with conn.cursor() as cursor:
        # 执行SQL查询
        sql = "SELECT * FROM `users` WHERE `name`=%s"
        cursor.execute(sql, ('John',))
        
        # 获取查询结果
        result = cursor.fetchall()
        print(result)
finally:
    conn.close()