python导出mysql数据_使用python导出mysql数据为csv文件

使用python导出mysql数据为csv文件

python3.7

pymysqlfrom pyecharts import Pie

import pymysql

import csv

import time

class View:

def __init__(self):

# 数据库配置

self.host = 'localhost'

self.database = '东方财富'

self.table = '上证指数2019_2'

self.user = 'root'

self.password = 'yjcyjc'

self.port = 3306

# csv储存

self.path = '.'

self.inputfilename = 'input.csv'

self.csvfilename = 'datas.csv'

self.logfilename = 'run.log'

def run(self):

strat = time.time()

rows=self.get_input()

print(len(rows))

with open('{}/{}'.format(self.path, self.csvfilename), 'a', encoding='utf_8_sig', newline='') as csvfile:

writ