SELECT COLUMN_NAME AS name,
if(
COLUMN_COMMENT is null or COLUMN_COMMENT='',
COLUMN_NAME,
COLUMN_COMMENT
) AS comment
FROM information_schema.COLUMNS WHERE TABLE_NAME='tableName'
mySQL 查询表字段及对应注释信息
最新推荐文章于 2022-12-30 11:57:18 发布
SELECT COLUMN_NAME AS name,
if(
COLUMN_COMMENT is null or COLUMN_COMMENT='',
COLUMN_NAME,
COLUMN_COMMENT
) AS comment
FROM information_schema.COLUMNS WHERE TABLE_NAME='tableName'