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"
);
查询所有数据库中包含某个字段的数据库表
最新推荐文章于 2023-04-18 11:08:05 发布