If you upgrade to mysql 5.0.x there are also the
The INFORMATION_SCHEMA tables that return meta information
about tables.
AFAIK they may not be available in pre 5.0 versions.
Keith
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:
http://marc.theaimsgroup.com/?l=php-install&m=114138567814319&w=2
On Fri, 17 Mar 2006, Yves Glodt wrote:
> To: mysql@stripped
> From: Yves Glodt <yves@stripped>
> Subject: getting table metadata
>
> Hi,
>
> 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,
> Yves
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
>
