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 wa
hese 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
>
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
>
ie("no
fields?\n");
$row_field_name = mysql_fetch_array($result_field_names);
$field_in_table = $row_field_name["Fields in the Table"];
> -Original Message-
> From: Mark Matthews [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 09, 2003 8:20 AM
> To: Karen Chu
&g
