SELECT
COLUMN_NAME,COLUMN_COMMENT,TABLE_SCHEMA,TABLE_NAME
FROM
information_schema.COLUMNS
WHERE
TABLE_SCHEMA = ‘目标数据库’
AND TABLE_NAME LIKE ‘表名’
AND (column_comment is null OR column_comment=’’)
查询没有注释的表字段
最新推荐文章于 2022-10-31 14:08:49 发布
SELECT
COLUMN_NAME,COLUMN_COMMENT,TABLE_SCHEMA,TABLE_NAME
FROM
information_schema.COLUMNS
WHERE
TABLE_SCHEMA = ‘目标数据库’
AND TABLE_NAME LIKE ‘表名’
AND (column_comment is null OR column_comment=’’)