cur = conn.cursor() cur.execute("""SELECT * FROM `db_name`.`table_name` LIMIT 10""") # 获取字段名 des = cur.description cols = [item[0] for item in des] # 获取数据 data_list=cur.fetchall() # 导出 csv import pandas as pd data = pd.DataFrame(data_list, columns=cols) # data.to_csv("table_name.csv", encoding="utf_8_sig")