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!
> -----Original Message----- > From: gerald_clark [mailto:[EMAIL PROTECTED] > Sent: Monday, June 09, 2003 6:33 AM > To: Karen Chu > Cc: [EMAIL PROTECTED] > Subject: Re: How to get meta data info in MySQL > > My database editor uses: > describe name; > > Karen Chu wrote: > > >I want to be able to get all table names in a database and all the > >column names and associated data type from a particular table. I wonder > >how to do that in MySQl. I understand I can use "show tables" to see the > >table info, but I want to be able to do 'select' in order to get the > >results back. I want to know if there is something like "select name > >from sysobject" in Sybase or "select name from all_tables" in Oracle. > > > >Thanks. I would appreciate any advice. > > > >Karen > > > > > > > > > > > > -- > 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]