retrieving table comment from mysql database

[windandwaves]

Hi Gurus

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.

- Nicolaas

[J.O. Aho]

windandwaves wrote:

Hi Gurus

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.

Comment saved in a PHP_My_Admin table.

[Gordon Burditt]

>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

[NC]

windandwaves wrote:

Is there a way to retrieve the table comment from
a mysql table.

Yes. Run a SHOW CREATE TABLE query on the table you want
to see the comment for. For example, if you have a table
called `example`, the query will be:

SHOW CREATE TABLE example;

It will return a CREATE TABLE statement for the table,
which will include the comment. You will need to parse
it out of the CREATE TABLE statement.

Cheers,
NC

[windandwaves]

NC wrote:

windandwaves wrote:

Is there a way to retrieve the table comment from
a mysql table.

Yes. Run a SHOW CREATE TABLE query on the table you want
to see the comment for. For example, if you have a table
called `example`, the query will be:

SHOW CREATE TABLE example;

It will return a CREATE TABLE statement for the table,
which will include the comment. You will need to parse
it out of the CREATE TABLE statement.

Thank you for clarifying this.

- Nicolaas

[windandwaves]

windandwaves wrote:

Hi Gurus

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.

- Nicolaas

This is the function I made up (I only use one space as indent):

function table_description($t) {
$sql = 'SHOW CREATE TABLE `'.$t.'`;';
$query = mysql_query($sql);
$v = mysql_result($query, 0, 1);
if($v) {
$p = strpos($v,"COMMENT=");
if($p) {
return substr($v, $p + 8);
}
}
return 'Table description not found';
}