python通过sqlalchemy导出mysql数据到excel表格中:
#sqlalchemy 导出mysql数据到excel
from sqlalchemy import create_engine
import pandas as pd
engine = create_engine('mysql+pymysql://username:password@localhost:3306/database_name')
sql = 'SELECT * FROM your_table'
df_read = pd.read_sql_query(sql, engine)
df_read.to_excel("D:\\your\\data.xlsx", index=False)
print("ok")