python-mysql：根据json形成公用方法之create篇

# ==============================================================
# -*- coding: utf-8 -*-
# ==============================================================
import json
import pymysql

def conn_mysql():
    conn = pymysql.connect('localhost','root','Aa111111','db_jxc')
    data = conn.cursor()
    sql = "DESC t_customer"
    data.execute(sql)
    data_table = data.fetchall()
    d = []
    for i in data_table:
        b = {}
        b['Field'] = i[0]
        b['Type'] = i[1]
        b['Default'] = i[4]
        d.append(b)
        jsonStr = json.dumps(d, ensure_ascii=False)
    print(jsonStr)
    str = "\r\n"
    jjj = json.loads(jsonStr)
    table_name = input("请输出新建的表名：\n")
    strj = " CREATE TABLE `"+table_name+"`("
    for item in jjj:
        str = str + "`%s` %s," % (item['Field'], item['Type'])
    str = str[:-1]
    print(str)
    print('\r\n')
    strNew = strj + str +')'
    print(strNew)
    data.close()
    conn.close()

conn_mysql()