查询 MySQL 数据库中已使用的字段类型清单

执行以下SQL语句，注意替换“你的数据库名”

SELECT 

    TABLE_NAME AS '表名', 

    COLUMN_NAME AS '字段名', 

    DATA_TYPE AS '类型', 

    IS_NULLABLE AS '允许空值',

    COLUMN_TYPE AS '详细定义'

FROM 

    information_schema.COLUMNS 

WHERE 

    TABLE_SCHEMA = '你的数据库名' 

    AND DATA_TYPE IN ('text', 'longtext', 'mediumtext', 'blob', 'json', 'enum', 'set', 'geometry')

ORDER BY 

    TABLE_NAME;