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, 'test', -1L), (2L, 'Test', -1L), (3L, 'Test2', -1L))
For MySQLdb you can initialize the connection so that result rows are
returned as dictionaries. (See the MySQLdb.cursorclass - I think -
module). There is also a description attribute of the cursor object. See
the DB API for details:
http://www.python.org/dev/peps/pep-0249/
Skip
--
http://mail.python.org/mailman/listinfo/python-list
