navicat mysql表结构导出excel并复制到word

 

 

select column_name as '字段名',
column_comment as '描述',
column_type as '数据类型',
column_key as 'KEY',
is_nullable as 'NULL',
column_default as '默认'
from information_schema.columns where table_schema='数据库名' and table_name='表名';