SELECT column_name , column_comment , data_typeFROM information_schema.columnsWHERE table_schema = 'DB_NAME'AND table_name = 'TABLE_NAME';
SHOW FULL COLUMNS FROM TABLE_NAME;