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
