python连接mysql方法

pip install mysql-connector-python

import mysql.connector

# 连接到MySQL数据库
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)

pip install pymysql

import pymysql

# 连接到MySQL数据库
conn = pymysql.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)

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

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

# 获取查询结果
results = cursor.fetchall()

for row in results:
  print(row)

# 关闭连接
conn.close()

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

from sqlalchemy import create_engine, Table, Column, Integer, String, MetaData
from sqlalchemy.orm import sessionmaker

# 创建数据库引擎
engine = create_engine('mysql+pymysql://yourusername:yourpassword@localhost/yourdatabase')

# 创建会话
Session = sessionmaker(bind=engine)
session = Session()

# 定义表结构
metadata = MetaData()
users = Table('users', metadata,
    Column('id', Integer, primary_key=True),
    Column('name', String(50)),
    Column('age', Integer)
)

# 插入数据
ins = users.insert().values(name='Alice', age=30)
session.execute(ins)
session.commit()

# 查询数据
result = session.execute("SELECT * FROM users")
for row in result:
    print(row)

# 关闭会话
session.close()