import pandas as pd
import pymysql
def pd_read_sql(tb_name, csv_path):
mysql_cn = connect_mysql() # 链接 mysql
df = pd.read_sql("select * from %s" % tb_name, con=mysql_cn)
df.to_csv(csv_path + tb_name + '.csv', index=False)
mysql_cn.close()