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';