[pymysql] 파이썬 DB > csv 변환

import pymysql
import pandas as pd

conn = pymysql.connect(host='localhost', port=3306, user='root', password='password', db ='emp', charset='utf8')
cursor = conn.cursor()
conn.commit()

sql = """SELECT * from employee"""
cursor.execute(sql)
rows = cursor.fetchall()
employees = pd.DataFrame(rows)
print(employees)
df = pd.read_sql_query(sql, conn)
df.to_csv(r'C:/project/result/db_to_csv.csv', index=False)


conn.commit()
conn.close()