to:[EMAIL PROTECTED]
Sent: Monday, June 09, 2003 8:20 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:
> I wish to have something like 'select name from all_
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Karen Chu wrote:
> Thanks for the reply!
> Please see my pseudo code below. @@@ mark is the place where my
> questions come from. I wonder if it is doable in MySQL.
>
> I wish to have code like this: (@@@ is where my questions come from)
> // connect
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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Karen Chu wrote:
> 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 ' too, but actual meta data is *stored* in systems
> tables. I wonder if MyS
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 " to
> get all column information for a table. But in the application
> programming, I want to be able to
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
>
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