mysql如何整理数据字典

CREATE TABLE custom_data_dictionary (
    table_name VARCHAR(255) NOT NULL,
    column_name VARCHAR(255) NOT NULL,
    data_type VARCHAR(255) NOT NULL,
    is_nullable BOOLEAN NOT NULL,
    column_key VARCHAR(255),
    extra VARCHAR(255),
    PRIMARY KEY (table_name, column_name)
);

INSERT INTO custom_data_dictionary (table_name, column_name, data_type, is_nullable, column_key, extra)
SELECT 
    TABLE_NAME, 
    COLUMN_NAME, 
    DATA_TYPE, 
    IS_NULLABLE, 
    COLUMN_KEY, 
    EXTRA 
FROM 
    information_schema.COLUMNS 
WHERE 
    TABLE_SCHEMA = 'your_database_name';

CREATE VIEW table_columns AS
SELECT 
    TABLE_NAME, 
    COLUMN_NAME, 
    DATA_TYPE, 
    IS_NULLABLE, 
    COLUMN_KEY, 
    EXTRA 
FROM 
    information_schema.COLUMNS 
WHERE 
    TABLE_SCHEMA = 'your_database_name';

TRUNCATE TABLE custom_data_dictionary;
INSERT INTO custom_data_dictionary (table_name, column_name, data_type, is_nullable, column_key, extra)
SELECT 
    TABLE_NAME, 
    COLUMN_NAME, 
    DATA_TYPE, 
    IS_NULLABLE, 
    COLUMN_KEY, 
    EXTRA 
FROM 
    information_schema.COLUMNS 
WHERE 
    TABLE_SCHEMA = 'your_database_name';