Python使用pandas & pymysql读取MySQL数据到csv文件中

# -*- coding: utf-8 -*-
 import pandas as pd
 import pymysqlconn = pymysql.connect(host='127.0.0.1', \
                user='root',password='', \
                db='mysql',charset='utf8', \
                use_unicode=True)sql = 'select * from tablename limit 1000'
 df = pd.read_sql(sql, con=conn)
 print(df.head())df.to_csv("data.csv")
 conn.close()