Home >Database >Mysql Tutorial >MySQL 找出使用了某列名的所有表
MySQL 找出使用了某列名的所有表
- WBOYOriginal
- 2016-06-07 14:54:451207browse
无详细内容 无 SELECT table_name,column_name FROM information_schema.columnsWHERE column_name LIKE '% tax %' Table_Name Column_namet_Customer tax_idt_Employee tax_numbert_Balance_sheet tax_percentage
SELECT table_name,column_name FROM information_schema.columns WHERE column_name LIKE '% tax %'
Table_Name Column_name t_Customer tax_id t_Employee tax_number t_Balance_sheet tax_percentage
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：枚举SQL中的Agent代理Next article：让SELECT 查询结果额外增加自动递增序号