无注释字段查询

use information_schema;
select COLUMNS.TABLE_NAME,TABLE_COMMENT,COLUMN_NAME,COLUMN_TYPE,COLUMN_COMMENT from tables,COLUMNS where tables.table_name = COLUMNS.table_name and COLUMNS.TABLE_SCHEMA=’dzyc’ and COLUMNS.COLUMN_COMMENT = ”