MYSQL show all general details of a table including its comments code example

Example: show table status command in mysql

SHOW TABLE STATUS FROM DB_name WHERE name = 'table_name';