#!/usr/bin/python
# -*- coding: UTF-8 -*-
import numpy as np
import mysql.connector
cnx = mysql.connector.connect(user='xxxx', password='xxxxx',
host='xxxx',
database='xxxx')
df=pd.read_sql_query("SELECT * FROM table xxx",cnx)
print(df)
使用read_sql_query函数即可,'xxxx'表示实际值,安全起见隐去