-- 查询哪些表包含字段 channelId=3 SELECT DISTINCT t.table_name, c.COLUMN_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLUMNS c ON c.TABLE_NAME = t.TABLE_NAME where t.TABLE_TYPE = 'base table' and c.COLUMN_NAME = '被包含字段x' and t.TABLE_SCHEMA = '指定的db库' ORDER BY t.TABLE_TYPE;
查询db里哪些表含有x字段
最新推荐文章于 2022-07-14 17:52:20 发布