SELECT TABLE_SCHEMA,TABLE_NAME FROM information_schema.`COLUMNS` WHERE COLUMN_NAME = 'col1'
col1为子段名。
MySql获取某个字段存在于在那个表
最新推荐文章于 2023-04-10 19:36:55 发布
SELECT TABLE_SCHEMA,TABLE_NAME FROM information_schema.`COLUMNS` WHERE COLUMN_NAME = 'col1'
col1为子段名。