Re: Re: How Do I Display a table description (PHP/MySQL question)
| From: | Aaron Schiff | Date: | Sun, 27 Jan 2008 06:03:56 +0000 |
| Subject: | Re: Re: How Do I Display a table description (PHP/MySQL question) | ||
| References: | 1 2 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-28759@lists.php.net to get a copy of this message | ||
Didn't even realize I sent it to you directly...I'm sending it to the list
to archive it.
Here's what I said:
For displaying table comments:
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA =
'your-table-name'
For displaying column comments:
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA =
'your-table-name'
On Jan 6, 2008 6:35 PM, none <ng@photobugbytes.com> wrote:
> Thanks for all the responses sent directly to me. I have it working now.
>
> ""none"" <ng@photobugbytes.com> wrote in message
> news:02.8B.16968.B74E0874@pb1.pair.com...
> > How do you display a table description that is part of a MySQL (v. 5.0)
> > database via PHP (v. 5.2) web page?
> >
> > Thanks
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
ts2do