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: No module named ‘MySQLdb‘所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。