php生成数据字典

分类: 文章 • 2024-06-14 19:29:04

效果如下：

php生成数据字典

对应的sql语句如下：

SELECT
    TABLE_SCHEMA as datebase,
    TABLE_NAME as tab_name,
    COLUMN_NAME as name,
    COLUMN_COMMENT as note
FROM
    information_schema. COLUMNS
WHERE
    TABLE_SCHEMA in( '库名1','car','库名4','information_schema','mysql','performance_schema','pro','statistics','库名2','supplymc','sys','库名3','zb') 
AND TABLE_NAME='{$tab_name}'

参考地址：https://www.kancloud.cn/he_he/thinkphp5/981157

php生成数据字典

相关推荐