MySQL怎么根据几个字段名确定表名

MySQL怎么根据几个字段名确定表名
注意注意：不是一个字段，是多个
谁会的

mysql中查询一个字段具体是属于哪一个数据库的那一张表：用这条语句就能查询出来,其中 table_schema 是所在库, table_name 是所在表
select table_schema,table_name from information_schema.columns where column_name = '字段名'

SELECT table_name FROM information_schema.columns WHERE TABLE_SCHEMA = 'DBName' AND COLUMN_NAME = 'columnName'

https://blog.csdn.net/yyy18237592983/article/details/80320955 https://blog.csdn.net/yyy18237592983/article/details/80320955
参考一下这个链接

SELECT TABLE_NAME FROM (SELECT TABLE_NAME,GROUP_CONCAT(COLUMN_NAME) AS cols FROM information_schema.columns WHERE TABLE_SCHEMA = '数据库名' GROUP BY TABLE_NAME) temp WHERE FIND_IN_SET('字段1', cols) AND FIND_IN_SET('字段2', cols)