通过 sql语句获得一个 表的备注 及 字段备注 类型

SELECT a.table_name,b.TABLE_COMMENT,a.COLUMN_NAME,a.COLUMN_TYPE,a.COLUMN_COMMENT FROM information_schema.columns a JOIN information_schema.TABLES b ON a.TABLE_SCHEMA =b.TABLE_SCHEMA AND a.TABLE_NAME =b.TABLE_NAME    WHERE a.TABLE_NAME='dlog';SELECT a.table_name,b.TABLE_COMMENT,a.COLUMN_NA