MySQL 找出使用了某列名的所有表
- WBOY原創
- 2016-06-07 14:54:451153瀏覽
无详细内容 无 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
陳述：
本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn