python连接MySQL：ModuleNotFoundError: No module named ‘MySQLdb‘

加入：

pymysql.install_as_MySQLdb()

API:

# coding:utf-8
import pymysql
import pandas as pd

pymysql.install_as_MySQLdb()

def pull_data(sql, dicts):
    conn = pymysql.connect(
        host=dicts['host'],
        user=dicts['user'],
        passwd=dicts['passwd'],
        db=dicts['db'],
        port=dicts['port'],
        charset=dicts['charset']
    )
    df = pd.read_sql(sql, conn)
    return df


if __name__ == '__main__':
    sql = 'select * from XXX"'
    dicts = {
        'host': 'XXX',
        'user': 'XXX',
        'passwd': 'XXX',
        'db': 'XXX',
        'port': 3306,
        'charset': 'utf8'
    }
    df = pull_data(sql, dicts)

最后

以上就是调皮大碗最近收集整理的关于python连接MySQL：ModuleNotFoundError: No module named ‘MySQLdb‘的全部内容，更多相关python连接MySQL：ModuleNotFoundError:内容请搜索靠谱客的其他文章。