python使用mysql的三个模块:mysql.connector、sqlalchemy、MySQLdb

时间:2022-11-23 18:17:47

在python中使用mysql其实很简单,只要先安装对应的模块即可,那么对应的模块都有什么?官方也没指定也没提供,pcat就推荐自己遇到的3个模块:mysql.connector、sqlalchemy、MySQLdb

------------------

1. 安装mysql.connector

MySQL Connector/Python is implementing the MySQL Client/Server protocol completely in Python. No MySQL libraries are needed, and no compilation is necessary to run this Python DB API v2.0 compliant driver.

git clone https://github.com/mysql/mysql-connector-python
cd mysql-connector-python
python setup.py
install

官方文档:

http://dev.mysql.com/doc/connector-python/en/

 

2. 安装sqlalchemy

SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL.

It provides a full suite of well known enterprise-level persistence patterns, designed for efficient and high-performing database access, adapted into a simple and Pythonic domain language.

git clone https://github.com/zzzeek/sqlalchemy
cd sqlalchemy
python setup.py
install

官方文档:

http://www.sqlalchemy.org/docs/

 

3. 安装MySQLdb

MySQL python client forked from MySQLdb, but support asyncronous query

原官网github:https://github.com/dccmx/mysqldb

但推荐下面的这个改进的

This is the legacy (1.x) version of MySQLdb. While it is still being maintained, there will not be a lot of new feature development.

git clone https://github.com/farcepest/MySQLdb1
cd MySQLdb1
python setup.py
install

这个MySQLdb其实不怎么推荐,另外如果要在windows里安装的话,推荐安装已经编译好的exe(不然源码安装的话各种问题):

http://www.codegood.com/downloads

里面MySQL-python-1.2.3.win-amd64-py2.7.exe、MySQL-python-1.2.3.win32-py2.7.exe分别为64位和32位版本

(如果安装MySQLdb后提示:ImportError DLL load failed: %1 不是有效的 Win32 应用程序,那么就安装个64位版本。

如果在64位系统里不能识别到安装在其他盘上的python目录,请参考这文:http://www.cnblogs.com/pcat/p/6021497.html

官方文档:请看github里doc文件夹里的文件