使用Python 比较mysql数据库中两个数据库的表结构，并导出差异部分的表结构_mysql表结构对比生成语句

使用Python比较数据库表结构和表字段

       废话不多说，直接上代码

# -*- coding: UTF-8 -*- 
# @Time    : 2018/8/31 8:23
# @Author  : wuming.wang
# @Email   : wuming.wang@tinno.com
# @File    : DiffDatabase.py
# @Software: PyCharm
 
import MySQLdb
import os
import sys
reload(sys)
sys.setdefaultencoding('utf-8')
 
base_dir = os.path.abspath(os.path.dirname(__file__))
 
 
class Diff:
    def __init__(self):
        self.test_host = '192.168.**.***'
        self.test_user_name = '****'
        self.test_password = '****'
        self.test_port = '3306'
        self.test_dbname = '****'
 
        self.online_host = '192.***.**.**'
        self.online_user_name = '**'
        self.online_password = '***'
        self.online_port = '3306'
        self.online_dbname = '*****'
 
    def get_data(self, env, sql):
        if env == "test":
            conn = MySQLdb.connect(self.test_host, self.test_user_name, self.test_password, self.test_dbname,
                                   charset="utf8")
        else:
            conn = MySQLdb.connect(self.online_host, self.online_user_name, self.online_password, self.online_dbname,
                                   charset="utf8")
 
        cur = conn.cursor()
        cur.execute(sql)
 
        results = cur.fetchall()  # 搜取所有结果
        cur.close()
        conn.close()
        return results
 
    # 把返回的嵌套元素转换为列表
    de