Only_Y_U的博客

目的：将表结构类型及注释导出到execl中 方案：通过sql查出表的结构，通过Navicat导出操作，导出到Excel sql如下： 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_