Posted by Gordon Burditt on 07/10/05 17:31

>Is there a way to retrieve the table comment from a mysql table.
>
>In PHP My Admin, you can set the comment for a table. however, I was
>wondering if you can retrieve it for use in a PHP page.
>
>Any help greatly appreciated.

In PHP 5.0.x, it's in information_schema.tables.table_comment .

It's also in SHOW CREATE TABLE in PHP 5.0.x and earlier versions.

Gordon L. Burditt

[Back to original message]