Pandas - 把MySQL中的数据导出到Excel表格

代码

import pandas as pd
import pymysql

conn = pymysql.connect(
    user="root",
    password="Chinais9?",
    database="test",
    charset="utf8"
)

df = pd.read_sql(
    "select * from journal limit 100",
    con=conn
)
df.to_excel("期刊100.xlsx", index=False)