mysql 查询数据库某字段类型的表

SELECT
TABLE_NAME,
COLUMN_NAME,
DATA_TYPE
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_SCHEMA = 'toys'
AND DATA_TYPE = 'float';