mysql查询数据字典sql

select CONCAT(c.TABLE_NAME,"(",t.TABLE_COMMENT,")"),c.COLUMN_NAME,c.COLUMN_TYPE,c.COLUMN_COMMENT from information_schema.columns c, INFORMATION_SCHEMA.TABLES t where c.TABLE_NAME = t.TABLE_NAME and c.TABLE_SCHEMA='test' ;