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?
((1L, 'test', -1L), (2L, 'Test', -1L), (3L, 'Test2', -1L))


-j

 

[Simon Forman]

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?

((1L, 'test', -1L), (2L, 'Test', -1L), (3L, 'Test2', -1L))


-j

k.description

See also http://www.python.org/dev/peps/pep-0249/

HTH,
~Simon

 

[Bob Kline]

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?

[d[0] for d in k.description]

Cheers,
Bob