#获取表注释:
SELECT table_name 表名,TABLE_COMMENT 表注释 FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = 'fish' ;#and table_name=''; #
fish:数据库名
#获取字段注释:
SELECT table_name,column_name,column_comment FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema ='fish' and table_name=''; #fish:数据库名
#添加表注释:
ALTER TABLE table_name COMMENT='这是表的注释';
#添加字段注释:
alter table t_pay_info modify column 字段名 字段类型 comment '这是字段注释';