查询所有数据库中包含某个字段的数据库表

SELECT
    TABLE_SCHEMA,
    TABLE_NAME,
    COLUMN_NAME
FROM
    information_schema. COLUMNS tt
WHERE
    column_name LIKE '%business_type%'
AND tt.TABLE_SCHEMA IN (
    "ems",
    "aas",
    "lms"
);