-----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]
