前言
多多点赞,会变好看!
多多留言,会变有钱!
Step1 安装pandas、openpyxl、sqlalchemy
pip install pandas openpyxl sqlalchemy
Step2 代码
import pandas as pd
from sqlalchemy import create_engine
# engine = create_engine('dialect+driver://username:password@host:port/database')
engine = create_engine('mysql+pymysql://root:*********@localhost:3306/stock')
sql = "SELECT * FROM dic_bk"
data = pd.read_sql(sql, engine)
print(data.head())
data.to_excel('d:/dic_bk.xlsx', index=None)
print("success")