mysql查看表注释和字段注释

• 说明在 mysql中information_schema这个数据库中保存了mysql中所有的数据库信息，
• 查看库中所有表和对应的注释

select table_name,table_comment from information_schema.tables where table_schema = 'bjsxt-his'

• 查看指定库下所有的表和表注释，字段和字段注释

select distinct 
a.table_name as name,
a.table_comment as comment,
b.COLUMN_NAME as columnname,
b.column_comment as comment,
b.column_type as columntype,
b.column_key as columnkey
from information_schema.TABLES a left join information_schema.COLUMNS b
on a.table_name = b.table_name 
where a.table_schema = 'bjsxt-his'

• 查看指定库下的表注释

select distinct 
a.table_name as name,
a.table_comment as comment,
b.COLUMN_NAME as columnname,
b.column_comment as comment,
b.column_type as columntype,
b.column_key as columnkey
from information_schema.TABLES a left join information_schema.COLUMNS b
on a.table_name = b.table_name 
where a.table_schema = 'bjsxt-his' and a.table_name = 'sys_menu'

• 学习源
  https://blog.csdn.net/weixin_39025362/article/details/108337016?spm=1001.2101.3001.6661.1&utm_medium=distribute.pc_relevant_t0.none-task-blog-2%7Edefault%7ECTRLIST%7ERate-1.pc_relevant_paycolumn_v3&depth_1-utm_source=distribute.pc_relevant_t0.none-task-blog-2%7Edefault%7ECTRLIST%7ERate-1.pc_relevant_paycolumn_v3&utm_relevant_index=1