python mysql desc

!/usr/bin/python import MySQLdb try : conn =MySQLdb.connect(host= ‘ localhost ‘ ,user= ‘ root ‘ ,passwd= ‘yourpasswd ‘ ,db= ‘yourdb ‘ ) cur = conn.cursor() cur.execute( ‘ desc bus_gps ‘ ) rows = cur.fetchall() desc = cur.description name_type_dict = {} for row in rows: name_type_dict[str(row[0])] =row[1 ] print row[0],row[1 ] cur.close() conn.close() print name_type_dict except MySQLdb.Error,e: print ‘ Mysql Error %d: %s ‘ % (e.args[0],e.args[1])

python mysql desc

标签：

查看更多关于python mysql desc的详细内容...