Python链接MySQL

最新推荐文章于 2025-09-08 20:55:49 发布

weixin_33774615

最新推荐文章于 2025-09-08 20:55:49 发布

阅读量82

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 python

原文链接：https://my.oschina.net/uxstone/blog/714619

本文对比了MySQLdb、mysqlclient及MySQLConnector/Python三种Python MySQL驱动的特点。MySQLdb为原生驱动，但不再支持Python3；mysqlclient是MySQLdb的一个分支，支持Python3，可作为MySQLdb的直接替代品；MySQLConnector/Python则是Oracle提供的纯Python驱动，无需额外库支持。

2019独角兽企业重金招聘Python工程师标准>>>

MySQLdb is a native driver that has been developed and supported for over a decade by Andy Dustman
mysqlclient is a fork of MySQLdb which notably supports Python 3 and can be used as a drop-in replacement for MySQLdb. At the time of this writing, this is the recommended choice for using MySQL with Django.
MySQL Connector/Python is a pure Python driver from Oracle that does not require the MySQL client library or any Python modules outside the standard library.

粗略总结下,

MySQLdb 不支持Python3了,

mysqlclient是forkMySQLdb ,能支持Python3

1.两者都可以用import MySQLdb 来导包

2.安装前需要libmysqlclient-dev

mysql-connector-python 是MYSQL官方提供的驱动

源码安装:

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

2.https://pypi.python.org/pypi/mysqlclient

3.https://pypi.python.org/pypi/mysql-connector-python

相关链接:

http://stackoverflow.com/questions/27748556/python3-4-cant-install-mysql-python