navicat生成数据字典
SELECT
t.TABLE_SCHEMA AS '库名称',
t.TABLE_NAME AS '表名',
t.COLUMN_NAME AS '字段名',
t.COLUMN_TYPE AS '字段类型',
IF
( t.COLUMN_DEFAULT = '', '空字符串', IFNULL ( t.COLUMN_DEFAULT, '无' ) ) AS '默认值',
t.COLUMN_COMMENT AS '字段备注'
FROM
information_schema.COLUMNS t
WHERE
TABLE_SCHEMA = '数据库名称' 
![[精选] 大佬们都喜欢看设计模式,你知道PHP设计模式有哪些呢?](https://blog.bee1001.com/zb_users/upload/2022/09/202209081033208913091.png)