python 导出mysql的数据表_python 导出 mysql表数据为 csv文件

# coding:utf8

import win32api

import win32con

import xlwt

import pymysql

import os

host = '127.0.0.1'

user = 'root'

pwd = '123456'

db = 'test'

sql = 'select * from master_worker'

sheet_name = '师傅信息'

DesktopPath = os.path.join(os.path.expanduser('~'),"Desktop")

out_path = DesktopPath + '\师傅信息.csv'

# print(out_path)

def export():

"""导出数据"""

conn = pymysql.connect(host,user,pwd,db,charset='utf8')

cursor = conn.cursor()

count = cursor.execute(sql)

print(count)

cursor.scroll(0,mode='absolute')

results = cursor.fetchall()

fields = cursor.description

workbook = xlwt.Workbook()

sheet = workbook.add_sheet(sheet_name,cell_overwrite_ok=True)

for field in range(0,len(fields)):

sheet.write(0,field,fields[field][0])

# row = 1

# col = 0

for row in range(1,len(results)+1):

# print(results[row - 1][1])

for col in range(0,len(fields)):

print(results[row - 1][col])

sheet.write(row,col,u'%s'%results[row-1][col])

# sheet.write(row,col,results[row-1][col])

workbook.save(out_path)

try:

export()

win32api.MessageBox(0, "导出数据 成功", "提示", win32con.MB_OK)

except Exception as e:

print(e)

win32api.MessageBox(0, "导出数据 失败\n%s"%e, "提示", win32con.MB_OK)