MySQL 中查找含有目标字段的表的方法_MySQL
- WBOYOriginal
- 2016-06-01 12:59:101002browse
代码如下:
SELECT TABLE_SCHEMA,TABLE_NAME
FROM information_schema.`COLUMNS`
WHERE COLUMN_NAME='字段名字'
参考：MySQL中，一个字段在多张表都存在，怎么用sql语句一次性查询这些表呢
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：12个优化MySQL的技巧小整理_MySQLNext article：大幅优化MySQL查询性能的奇技淫巧_MySQL