select table_name from information_schema.columns
where TABLE_SCHEMA='DBName' and COLUMN_NAME='columnName'
解释一下:
DBName: 要查询的数据库名称;
columnName: 你所知道的列;
————————————————
原文链接:https://blog.csdn.net/yyy18237592983/article/details/80320955
select table_name from information_schema.columns
where TABLE_SCHEMA='DBName' and COLUMN_NAME='columnName'
解释一下:
DBName: 要查询的数据库名称;
columnName: 你所知道的列;
————————————————
原文链接:https://blog.csdn.net/yyy18237592983/article/details/80320955
本文标题:2019-11-06 mysql根据字段查表名
本文链接:https://www.haomeiwen.com/subject/wfgubctx.html
网友评论