MySql查看表信息

SELECT TABLE_NAME, TABLE_COMMENT -- 指定信息列
FROM `information_schema`.`tables` A
WHERE A.`TABLE_SCHEMA` = '库名'
AND A.`TABLE_COMMENT` = '' -- 其余条件