1. from sqlalchemy import create_engine import pandas as pd con = create_engine('mysql+pymysql://User Name:Password@Host/tabel') data = pd.read_sql_tabel('tabel_name', con) data.to_csv('table_name.csv',encoding='utf_8_sig') # 防止乱码