-- table_name='查询表名称' and table_schema='数据库名称'

select table_schema,table_name,column_name,column_comment,data_type

from information_schema.columns

where column_name like '%bank%'