Mysql导出表结构到Excel

查询所有数据库内所有表和表注释

 

SELECT
table_name 表名,
table_comment 表说明
FROM
information_schema.TABLES
WHERE
table_schema = (SELECT DATABASE())
ORDER BY
table_name

 

查询所有数据表内的字段和注释

set @i := 0;
SELECT
@i := @i + 1 AS 序号,
t.COLUMN_NAME AS 字段,
t.column_key 约束类型,
(
CASE
WHEN t.IS_NULLABLE = 'YES' THEN
'true'
ELSE
'false'
END
) AS 是否可以为空,
t.COLUMN_DEFAULT 默认值, 
t.COLUMN_COMMENT AS 备注,
t.COLUMN_TYPE AS 类型
FROM
information_schema.`COLUMNS` t
WHERE
t.TABLE_SCHEMA = (SELECT DATABASE())
AND t.TABLE_NAME = 'app_user';

复制数据到Excel