记录一下,方便使用
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='表名'
记录一下,方便使用
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='表名'