MySQLdb for Python3.7 and read SQL databases

下载 https://pypi.org/project/mysqlclient/#files 

 

下载后 将文件存储在Script文件夹下

pip install mysqlclient-1.4.2.post1-cp37-cp37m-win_amd64.whl

即可

python

import MySQLdb

读取数据库

def read_sql(db='database_name'):
       user = 'name'
       pwd= 'password'
       ip = '101.10.101.23'
       port = 3306
       conn_modeling = MySQLdb.connect(host=ip, db=db, user=user, passwd=pwd ,port=port, charset='utf8')
       return conn_modeling

conn = read_sql("you want read database's name")
messages = pd.read_sql("select * from tablename",conn)

调用函数的方式 来读取数据库里的表