使用 Python 连接 MySQL 的方法

# 前置条件sudo apt-get install python-dev libmysqlclient-dev 
# Ubuntusudo yum install python-devel mysql-devel 
# Red Hat / CentOS
# 安装pip install MySQL-python

#!/usr/bin/pythonimport MySQLdbdb = MySQLdb.connect( host="localhost", 
# 主机名 user="john", 
# 用户名 passwd="megajonhy", 
# 密码 db="jonhydb") 
# 数据库名称
# 查询前，必须先获取游标cur = db.cursor()
# 执行的都是原生SQL语句cur.execute("SELECT * FROM YOUR_TABLE_NAME")for row in cur.fetchall(): print(row[0])db.close()

# Windows安装pip install some-package.whl# linux 前置条件sudo apt-get install python3-dev # debian / Ubuntusudo yum install python3-devel # Red Hat / CentOSbrew install mysql-connector-c # macOS (Homebrew)pip install mysqlclient

pip install PyMySQL
# 为了兼容mysqldb，只需要加入pymysql.install_as_MySQLdb()

import pymysqlconn = pymysql.connect(host='127.0.0.1', user='root', passwd="xxx", db='mysql')cur = conn.cursor()cur.execute("SELECT Host,User FROM user")for r in cur: print(r)cur.close()conn.close()

pip install peewee

import peeweefrom peewee import *db = MySQLDatabase('jonhydb', user='john', passwd='megajonhy')class Book(peewee.Model): author = peewee.CharField() title = peewee.TextField() class Meta: database = dbBook.create_table()book = Book(author="me", title='Peewee is cool')book.save()for book in Book.filter(author="me"): print(book.title)

from sqlalchemy import create_enginefrom sqlalchemy.orm import sessionmakerfrom sqlalchemy_declarative import Address, Base, Personclass Address(Base): __tablename__ = 'address' id = Column(Integer, primary_key=True) street_name = Column(String(250))engine = create_engine('sqlite:///sqlalchemy_example.db')Base.metadata.bind = engineDBSession = sessionmaker(bind=engine)session = DBSession()# Insert a Person in the person tablenew_person = Person(name='new person')session.add(new_person)session.commit()