navicat导出表结构到Excel 带字段备注 

SELECTCOLUMN_NAME AS '字段名称',COLUMN_TYPE AS '字段类型',
IF( IS_NULLABLE = 'NO', '否', '是' ) AS '是否必填',COLUMN_COMMENT AS '注释' 
FROMINFORMATION_SCHEMA.COLUMNS 
WHERE
-- 数据库名table_schema = 'vmscenter' 
-- 表名AND table_name = 'yczhxx';