mysql fieldnames

[rdack]

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]

Here's the code I use for it:

http://cvs.sourceforge.net/cgi-bin/...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

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/

 

[BadJake]

You can execute the queries
SHOW DATABASES;
or
SHOW COLUMNS FROM your_table_name

Regards
John