Python 数据库字段类型对应代码

 ft = MySQLdb.constants.FIELD_TYPE 
 d = {getattr(ft, k): k for k in dir(ft) if not k.startswith('_')} 
 d 
{0: 'DECIMAL', 
1: 'TINY', 
2: 'SHORT', 
3: 'LONG', 
4: 'FLOAT', 
5: 'DOUBLE', 
6: 'NULL', 
7: 'TIMESTAMP', 
8: 'LONGLONG', 
9: 'INT24', 
10: 'DATE', 
11: 'TIME', 
12: 'DATETIME', 
13: 'YEAR', 
14: 'NEWDATE', 
15: 'VARCHAR', 
16: 'BIT', 
246: 'NEWDECIMAL', 
247: 'INTERVAL', 
248: 'SET', 
249: 'TINY_BLOB', 
250: 'MEDIUM_BLOB', 
251: 'LONG_BLOB', 
252: 'BLOB', 
253: 'VAR_STRING', 
254: 'STRING', 
255: 'GEOMETRY'}