SELECT table_name FROM information_schema.columns WHERE TABLE_SCHEMA = 'fe-space' AND COLUMN_NAME='state'

fe-space:数据库名称

state：要查询的字段名

其他粘贴复制