读取为pandas格式
def conn2mysql(sql):
from pandas import read_sql
from pymysql import connect
conn = connect(host="192.168.32.XXX", user="root",password="123456",database="test",charset="utf8")
df=read_sql(sql,conn)
conn.close()
return df
df = conn2mysql('select * from business')
df
在python里面直接操作数据库
import pymysql
conn = pymysql.connect(host="192.168.32.xxx", user="root",password="123456",database="test",charset="utf8")
cur = conn.cursor()
sql = 'select * from business'
cur.execute(sql)
cur.fetchall()