renjingkai的博客

MySQL数据库查询某个字段所在的表名：精确查询语句如下：SELECT * FROM information_schema.columns WHERE column_name='column_name';模糊匹配查询语句如下：SELECT * FROM information_schema.columns WHERE column_name LIKE '%column_name%';Oracle数据库查询某个字段所在的表名：精确查询语句如下：SELECT column_.