List:General Discussion« Previous MessageNext Message »
From:mysql Date:March 17 2006 3:28pm
Subject:Re: getting table metadata
View as plain text  
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
> 
> 
Thread
getting table metadataYves Glodt17 Mar
  • Re: getting table metadataMartijn Tonies17 Mar
    • Re: getting table metadataYves Glodt17 Mar
      • Re: getting table metadataКосов Евгений17 Mar
      • RE: getting table metadataGordon17 Mar
  • Re: getting table metadatamysql17 Mar
  • Re: getting table metadataMartijn Tonies17 Mar
    • Re: getting table metadataYves Glodt17 Mar