Python中的MySQL接口：PyMySQL & MySQLdb

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

PyMySQL支持 Python3.0以后的版本

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
  • IronPython2.7
• MySQL Server -- one of the following:
  • MySQL>= 4.1 (tested with only 5.5~)
  • MariaDB>= 5.1

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

Python interface to MySQL

MySQLdb is an interface to the popularMySQLdatabase 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.