import pymysql
import pandas as pd
import numpy as np
import datetime
def tp_data():
#获取数据
db=pymysql.connect(host=,port=3306,user=,password=)
cursor=db.cursor()
cursor.execute()
data=cursor.fetchall()
data_dict=[]
for field in cursor.description:
data_dict.append(field[0])
return data,data_dict
DF=tp_data()[0] # 表数据
columns=tp_data()[1] # 表头
更多推荐
python获取mysql表头名称
发布评论