SELECT table_name FROM information_schema.columns WHERE TABLE_SCHEMA = 'fe-space' AND COLUMN_NAME='state'
fe-space:数据库名称
state:要查询的字段名
其他粘贴复制
SELECT table_name FROM information_schema.columns WHERE TABLE_SCHEMA = 'fe-space' AND COLUMN_NAME='state'
fe-space:数据库名称
state:要查询的字段名
其他粘贴复制