getting database column names from query

[Jason Nordwick]

I'm using MySQLdb and can connect and issue queries that return result sets, but I how do I get the column names for those result sets?

>>> c = MySQLdb.connect(*creds)
>>> k = c.cursor()
>>> k.execute("select * from account")
3L
>>> k.fetchall()
((1L, 'test', -1L), (2L, 'Test', -1L), (3L, 'Test2', -1L))


-j