mysql fieldnames

[Mike C. Fletcher]

Here's the code I use for it:

http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/pytable/table/pytable/mysql/tableactions.py?rev=HEAD&content-type=text/vnd.viewcvs-markup

(You can scroll down to the bottom to see the low-level queries).

Basically MySQL has a "show" SQL query for the database types.  You can 
use regular DB-API calls to get the results of running those queries.

HTH,
Mike

rdack wrote:

>how can i retrieve database names and fieldnames from mysql 4 using
>MySQLdb 0.9.2 from python 2.3?
>(on mac osx 10.2.6)
>  
>
_______________________________________
  Mike C. Fletcher
  Designer, VR Plumber, Coder
  http://members.rogers.com/mcfletch/