If you upgrade to mysql 5.0.x there are also the
The INFORMATION_SCHEMA tables that return meta information
AFAIK they may not be available in pre 5.0 versions.
In theory, theory and practice are the same;
in practice they are not.
To unsubscribe from this list, please see detailed
instructions already posted at:
On Fri, 17 Mar 2006, Yves Glodt wrote:
> To: mysql@stripped
> From: Yves Glodt <yves@stripped>
> Subject: getting table metadata
> is it possible to get information about tables by doing queries on some system
> tables? I am using mysql version 4.1.11 on debian sarge.
> In my case I need to know which columns (names and types) a table has, and how
> the primary key is defined.
> How can I get this information out of mysql by only using sql ?
> Best regards,
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1