Jason> I'm using MySQLdb and can connect and issue queries that return
Jason> result sets, but I how do I get the column names for those result
Jason> sets?
>>> c = MySQLdb.connect(*creds)
>>> k = c.cursor()
>>> k.execute("select * from account")
3L
>>> k.fetchall
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?
[d[0] for d in k.description]
Cheers,
Bob
--
http://mail.python.org/mailman/listinfo/python-list
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'
