List:General Discussion« Previous MessageNext Message »
From:Karen Chu Date:June 9 2003 3:16pm
Subject:RE: How to get meta data info in MySQL
View as plain text  
I wish to have something like 'select name from all_tables' in oracle or
'select name from sysobjects' in Sybase. Oracle has 'show tables' or
'describe <table>' too, but actual meta data is *stored* in systems
tables. I wonder if MySQL also stores these in system tables or files or
somewhere else.

> -----Original Message-----
> From: Mark Matthews [mailto:mark@stripped]
> Sent: Monday, June 09, 2003 7:30 AM
> To: Karen Chu
> Cc: 'gerald_clark'; mysql@stripped
> Subject: Re: How to get meta data info in MySQL
> 
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> Karen Chu wrote:
> 
> > Thanks for the reply! Yes, I understand I can do "show tables" to
show
> > all table names in a database and I can do "describe <table_name>"
to
> > get all column information for a table. But in the application
> > programming, I want to be able to do 'select' and be able to see
"table
> > names" and "column info" as a query result set. Can MySQL do that?
There
> > must be a place to store this information. In oracle or Sybase,
these
> > are store in system tables (actual table) so I can do 'select' from
them
> > to get a result set. I am new to MySQL. I wonder where these meta
data
> > stored in MySQL. Any thoughts are appreciated. Thanks!
> >
> 
> Either of those commands (show/describe) return the data in a result
set
> form. Is there a reason that doesn't work for you?
> 
> 	-Mark
> 
> 
> - --
> For technical support contracts, visit
https://order.mysql.com/?ref=mmma
> 
>     __  ___     ___ ____  __
>    /  |/  /_ __/ __/ __ \/ /  Mark Matthews <mark@stripped>
>   / /|_/ / // /\ \/ /_/ / /__ MySQL AB, SW Dev. Manager - J2EE/Windows
>  /_/  /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
>         <___/ www.mysql.com
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.1 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
> 
> iD8DBQE+5JnhtvXNTca6JD8RAkm2AKCNzJUSCLnrzXKvAMnmQ2W5cwzYoQCfVbPn
> okkkEY8/4XQL91gUyQw6zQw=
> =jZ+B
> -----END PGP SIGNATURE-----
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

Thread
How to get meta data info in MySQLKaren Chu8 Jun
  • Re: How to get meta data info in MySQLgerald_clark9 Jun
    • RE: How to get meta data info in MySQLKaren Chu9 Jun
      • Re: How to get meta data info in MySQLMark Matthews9 Jun
        • RE: How to get meta data info in MySQLKaren Chu9 Jun
          • Re: How to get meta data info in MySQLMark Matthews9 Jun
            • RE: How to get meta data info in MySQLKaren Chu9 Jun
              • Re: How to get meta data info in MySQLMark Matthews9 Jun
              • RE: How to get meta data info in MySQLPaul DuBois9 Jun
          • Compiling MySQL 5 TreePrimaria Falticeni14 Jun
            • Just a testScott Haneda15 Jun
              • [BUG] show full processlist on AIXAres Liu15 Jun
                • Re: [BUG] show full processlist on AIXJeremy Zawodny16 Jun
            • ERROR 1005: Can't create table './db/table.frm' (errno: 150)Ben Clewett16 Jun
Re: ERROR 1005: Can't create table './db/table.frm' (errno: 150)Heikki Tuuri16 Jun