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
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',
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 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()
((1L,