PHP MySQL How to get table comments
$sql = "Show create table about";
$query =mysql_query ($sql);
How do I write the following to get the table comments?
Thank you.
------Solution--------------------
Field?
The proud frog has the answer
SELECT column_name, Data_type, column_comment
From Information_schema.columns
WHERE table_name =?
------Solution--------------------
A table comment or a field comment?
Table annotations can be used
SQL code
show table status like table name
------ Solution--------------------
SQL code
show table status lik E ' table name '
------Solution--------------------
The old brother is still breathing the air of nature ...
discussion
SQL Code
Show Table status like ' table name '
------solution--------------------
discussion
The old brother is still calling
Suck the air of nature ...
Reference:
SQL Code
Show Table status like ' table name '