我想在sql中的所有表中查询哪些表存在co1这个字段怎么弄,

[tian790317]

在mysql中,我想在sql中的所有表中查询哪些表存在co1这个字段怎么弄,

[ayzen1988]

如果有权限的话 可以用下面的sql

use information_schema;
select TABLE_SCHEMA,TABLE_NAME from `COLUMNS` where COLUMN_NAME = 'co1';

[ACMAIN_CHM]

SELECT table_name FROM INFORMATION_SCHEMA.COLUMNS WHERE column_name LIKE 'co1'

[Rotel-刘志东]

select table_name from information_schema.columns where column_name like '%co1%';

[ermuzi]

SELECT TABLE_SCHEMA,TABLE_NAME FROM information_schema.COLUMNS where COLUMN_NAME = 'co1';