我可以查询MYSQL的特定数据类型吗?

时间:2021-05-19 16:59:48

Can I query a MYSQL database for what tables use a specific datatype?

我可以查询一个MYSQL数据库来查找使用特定数据类型的表吗?

For example: We are wanting to use CakeDC migrations (For CakePHP) which do not support database specific features such as enums. How would I get a comprehensive list of which tables use enums so we can get an idea of how our system might be affected?

例如:我们希望使用CakeDC迁移(用于CakePHP),它不支持数据库特定的特性,比如枚举。如何获得使用枚举的表的全面列表,从而了解系统可能受到的影响?

1 个解决方案

#1


3  

SELECT *
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE DATA_TYPE = 'enum';

#1


3  

SELECT *
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE DATA_TYPE = 'enum';