Re: getting database column names from query

[Simon Forman]

Jason Nordwick wrote:
> 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

k.description

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

HTH,
~Simon

-- 
http://mail.python.org/mailman/listinfo/python-list