NoSuchModuleError: Can‘t load plugin: sqlalchemy.dialects:mysql.pymysql

import pandas as pd
import numpy as np
from sqlalchemy import create_engine


sql = 'select * from products'
engine = create_engine('mysql+pymysql://root:passwd@localhost:3306/test_db?charset=utf8')
#engine = create_engine('mysql+pymysql://root:passwd@127.0.0.1:3306/test_db?charset=utf8')
#engine = create_engine("mysql://root:passwd@127.0.0.1:3306/test_db")
pd.read_sql(sql.engine)
Traceback (most recent call last):

  File "<ipython-input-131-bca3f1a0fc5b>", line 1, in <module>
    runfile('C:/D/mypython/泰坦尼克/mysqlpd.py', wdir='C:/D/mypython/泰坦尼克')

  File "C:\D\anaconda\lib\site-packages\spyder_kernels\customize\spydercustomize.py", line 678, in runfile
    execfile(filename, namespace)

  File "C:\D\anaconda\lib\site-packages\spyder_kernels\customize\spydercustomize.py", line 106, in execfile
    exec(compile(f.read(), filename, 'exec'), namespace)

  File "C:/D/mypython/mysqlpd.py", line 10, in <module>
    engine = create_engine('mysql+pymysql://root:*****@localhost:3306/test_db?charset=utf8')

  File "C:\D\anaconda\lib\site-packages\sqlalchemy\engine\__init__.py", line 387, in create_engine
    return strategy.create(*args, **kwargs)

  File "C:\D\anaconda\lib\site-packages\sqlalchemy\engine\strategies.py", line 56, in create
    entrypoint = u._get_entrypoint()

  File "C:\D\anaconda\lib\site-packages\sqlalchemy\engine\url.py", line 139, in _get_entrypoint
    cls = registry.load(name)

  File "C:\D\anaconda\lib\site-packages\sqlalchemy\util\langhelpers.py", line 218, in load
    (self.group, name))

NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:mysql.pymysql

搞不清哪里错了,先记下来吧

  • 2
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 7
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 7
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值