1:
SELECT * from (select column_name,TABLE_NAME from information_schema.columns where table_schema ='数据库名') a where a.column_name = "字段名"
eg:
2:
SELECT * FROM information_schema.columns WHERE column_name='saler_id';
1:
SELECT * from (select column_name,TABLE_NAME from information_schema.columns where table_schema ='数据库名') a where a.column_name = "字段名"
eg:
2:
SELECT * FROM information_schema.columns WHERE column_name='saler_id';