mysql select all table that have field names

Solutions on MaxInterview for mysql select all table that have field names by the best coders in the world

we are a community of more than 2 million smartest coders
registration for
employee referral programs
are now open
get referred to google, amazon, flipkart and more
register now
  
pinned-register now
showing results for - "mysql select all table that have field names"
Antonio
03 Mar 2017
1SELECT DISTINCT
2	TABLE_NAME
3FROM
4	INFORMATION_SCHEMA.COLUMNS
5WHERE
6	COLUMN_NAME IN('column1', 'column2')
7	AND TABLE_SCHEMA = 'schema_name';
8