Problem
You have a query executed by MySQL Connector/Python and would like to show column information nicely on the console.
Solution
Every cursor object has a description property. This can be used to show information about the columns in a result set.
columns = []
maxnamesize = 0
for coldesc in cur.description:
coldesc = list(coldesc)
coldesc[2:6] = []
columns.append(coldesc)
namesize = len(coldesc[0])
if namesize > maxnamesize:
maxnamesize = namesize
fmt = "{{nr:3}} {{name:{0}}} {{type:12}} {{null}}".format(
maxnamesize+1)
colnr = 1
for column in columns:
(colname, fieldtype, nullok, colflags) = column
print(fmt.format(
nr=colnr,
name=colname,
null='NOT …[Read more]