mysql查询某个库下面每个表名与表名注释

SELECT
table_name AS '表名',
table_comment AS '表注释'
FROM
information_schema.TABLES
WHERE
table_schema = '你的数据库名称'

posted @ 2024-05-07 11:03   不将就鸭  阅读(14)  评论(0)    收藏  举报