Python连接数据库：pymysql

最新推荐文章于 2025-02-24 20:34:30 发布

Holidaylovesam

最新推荐文章于 2025-02-24 20:34:30 发布

阅读量1k

点赞数 1

CC 4.0 BY-SA版权

分类专栏：数据库 Python 文章标签： mysql

本文链接：https://blog.csdn.net/alice_tl/article/details/96269726

安装连接SQL的依赖库

常用的依赖库有MySQLdb、pyMysql

最初尝试了mysqldb，pip install mysqldb安装时报错，ERROR: Could not find a version that satisfies the requirement mysqldb (from versions: none)
ERROR: No matching distribution found for mysqldb

网上搜了下可能是如下几个原因：

python 3.6.1以上版本不支持MySQLdb
pip版本问题

所以放弃了，选择了另一个依赖库pymysql

(base) bogon:~ alice$ python
Python 3.7.3 (v3.7.3:ef4ec6ed12, Mar 25 2019, 16:39:00) 
[GCC 4.2.1 (Apple Inc. build 5666) (dot 3)] on darwin
Type "help", "copyright", "credits" or "license" for more information.
>>> import MySQLdb
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
ModuleNotFoundError: No module named 'MySQLdb'
>>> quit()
(base) bogon:~ alice$ pip install mysqldb
Collecting mysqldb
  ERROR: Could not find a version that satisfies the requirement mysqldb (from versions: