php - Information Schema Table Description / Comment -

php - Information Schema Table Description / Comment -

what query code extract table comment/description? column descriptions easy. there url or list of various queries , options can perform on info schema , applicable column-names options?

thank you.

to clarify:

$sql = "select table_comment information_schema.column_name `table_schema` = '$dbnm' , table_name = '$tbl_nm' limit 1";

this turns out nil (obviously) need pull out exact description of table in question, individually not show info on particular table.

i need in form can run sql query on create usable....

... information_schema.column_name ...

there no such table called column_name in information_schema.

if want table comments, utilize query:

$sql = "select table_comment information_schema.tables table_schema = '$dbnm' , table_name = '$tbl_nm'";

if want reference documentation tables in info schema , columns try: http://dev.mysql.com/doc/refman/5.6/en/information-schema.html

or else view yourself:

mysql> show tables information_schema; mysql> desc information_schema.tables;

php mysql table comments information-schema