pymysql blob mysql_关于pymysql的一些总结

关于pymysql的一些总结

# -*- coding: utf-8 -*-

# File : 总结性的数据库.py

# Author: HuXianyong

# Date : 2018-08-16 11:18

import pymysql,re

def testing():

msg = '''

继续输入,请按1

退出,请按q

'''

keyList = []

valueList = []

dic = {}

typeList = ["BIT", "BOOL", "TINYINT", "SMALLINT", "MEDIUMINT", "INT", "BIGINT", "FLOAT", "DOUBLE", "DECIMAL",

"CHAR", "VARCHAR", "TINYTEXT", "TEXT", "MEDIUMTEXT", "LONGTEXT", "TINYBLOB", "BLOB", "MEDIUMBLOB",

"LONGBLOB", "Date", "DateTime", "TimeStamp", "Time", "Year", "BINARY", "VARBINARY", "ENUM", "SET",

"Geometry", &#