python读取excel生成mysql建表语句_用Python脚本自动生成MySQL表创建语句,python,mysql,建表...

自动生成mysql建表语句

平时在设计完表结构后，还得写建表语句，其实可以让脚本来完成这样重复的工作，python代码如下

# -*- coding=utf-8 -*-

#coding=utf-8

import xlrd

import os

def convert_type(data_type):

"""Normalize MySQL `data_type`"""

if 'CHAR' == data_type:

return 'varchar'

elif 'CLNT' == data_type:

return 'varchar'

elif 'NUMC' == data_type:

return 'numeric'

elif 'DATS' == data_type:

return 'timestamp'

elif 'QUAN' == data_type:

return 'varchar'

elif 'CUKY' == data_type:

return 'varchar'

elif 'CURR' == data_type:

return 'varchar'

elif 'DEC' == data_type:

ret