mysql生成在线数据字典

SELECT 
    TABLE_SCHEMA AS 'Database',
    TABLE_NAME AS 'Table',
    TABLE_TYPE AS 'Type',
    ENGINE AS 'Engine',
    CREATE_TIME AS 'Create Time'
FROM 
    information_schema.TABLES
WHERE 
    TABLE_SCHEMA = 'your_database_name'
ORDER BY 
    TABLE_NAME;

-- 示例：只查询特定数据库的表信息
SELECT 
    TABLE_SCHEMA AS 'Database',
    TABLE_NAME AS 'Table',
    TABLE_TYPE AS 'Type',
    ENGINE AS 'Engine',
    CREATE_TIME AS 'Create Time'
FROM 
    information_schema.TABLES
WHERE 
    TABLE_SCHEMA = 'your_database_name'
ORDER BY 
    TABLE_NAME;

-- 示例：创建一个自定义的数据字典表
CREATE TABLE custom_data_dictionary (
    id INT AUTO_INCREMENT PRIMARY KEY,
    table_schema VARCHAR(64),
    table_name VARCHAR(64),
    table_type VARCHAR(64),
    engine VARCHAR(64),
    create_time DATETIME
);

-- 示例：创建触发器，在表创建时更新自定义数据字典
DELIMITER $$
CREATE TRIGGER after_table_create
AFTER CREATE ON your_database_name.*
FOR EACH ROW
BEGIN
    INSERT INTO custom_data_dictionary (table_schema, table_name, table_type, engine, create_time)
    VALUES (NEW.TABLE_SCHEMA, NEW.TABLE_NAME, NEW.TABLE_TYPE, NEW.ENGINE, NEW.CREATE_TIME);
END$$
DELIMITER ;