需求:Python将mysql中表导出为Excel表格
mysql表中的数据:
测试环境:
平台:Windows10、centos7
python版本:python3.7(以下脚本兼容python2)
python库安装:
pip install pymysql
pip install MySQLdb
pip install xlwt
新建py——python_mysql_excel.py
# coding: utf-8
# author: sirxy
# created_time: 2020/12/23
import sys
import xlwt
# 当前的python版本
if sys.version_info >= (3, 0):
import pymysql as mysql
else:
import MySQLdb as mysql
# mysql信息
host = '127.0.0.1'
port = 3306
user =