查询mysql包含某个字段的所有表 show  tables  like 'crm_%'   MYSQL根据字段查表名 SELECT table_name, column_name from information_schema.columns WHERE column_name LIKE 'Name';   SELECT column_name from information_schema.columns WHERE column_name LIKE ’%searchTerm%’ AND table_schema = ‘yourDB’   SELECT column_name from information_schema.columns W…继续阅读 »