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:[EMAIL PROTECTED] > Sent: Monday, June 09, 2003 7:30 AM > To: Karen Chu > Cc: 'gerald_clark'; [EMAIL PROTECTED] > 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 <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]