Python中的MySQL接口：PyMySQL & MySQLdb

MySQLdb模块只支持MySQL-3.23到5.5之间的版本，只支持Python-2.4到2.7之间的版本

PyMySQL支持 Python3.0以后的版本

 

PyMySQL

https://pypi.python.org/pypi/PyMySQL  

https://github.com/PyMySQL/PyMySQL/blob/master/README.rst

• Python -- one of the following:
  • CPython >= 2.6 or >= 3.3
  • PyPy >= 4.0
  • IronPython 2.7
• MySQL Server -- one of the following:
  • MySQL >= 4.1 (tested with only 5.5~)
  • MariaDB >= 5.1

 

MySQLdb

https://pypi.python.org/pypi/MySQL-python/1.2.5

MySQL-python 1.2.5

Downloads ↓

Python interface to MySQL

MySQLdb is an interface to the popular MySQL database server for Python. The design goals are:

• Compliance with Python database API version 2.0 [PEP-0249]
• Thread-safety
• Thread-friendliness (threads will not block each other)

MySQL-3.23 through 5.5 and Python-2.4 through 2.7 are currently supported. Python-3.0 will be supported in a future release. PyPy is supported.