SELECt * FROM information_schema.`COLUMNS` WHERe table_name = 'activity' ORDER BY COLUMN_NAME
对应查询结果:
SELECt COLUMN_NAME,COLUMN_COMMENT FROM information_schema.`COLUMNS` WHERe table_name = 'activity' ORDER BY COLUMN_NAME
对应查询结果:

SELECt * FROM information_schema.`COLUMNS` WHERe table_name = 'activity' ORDER BY COLUMN_NAME
对应查询结果:
SELECt COLUMN_NAME,COLUMN_COMMENT FROM information_schema.`COLUMNS` WHERe table_name = 'activity' ORDER BY COLUMN_NAME
对应查询结果: