python获取mysql表的数据，保存到pandas DataFrame

 

 

import pymysql
import pandas as pd
def con_sql(sql):
# 创建连接
    db = pymysql.connect(
        host='0.0.0.0',
        user='aaa',
        password='bbb',
        database='ccc',
        charset='utf8')
# 创建游标
    cursor = db.cursor()
    cursor.execute(sql)
    result = cursor.fetchall()
#执行结果转化为dataframe
    df = pd.DataFrame(list(result))
# 关闭连接
    db.close()
#返回dataframe
    return df


sql = "SELECT * FROM tableABC"
result = con_sql(sql)
print(result)#