Mysql

Mysql snippet

To get all tables with columns ‘column-name1’ or ‘column-name2’ in the database ‘Database-Name’ SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME IN ( ‘column name1’, ‘column name2’ ) AND TABLE_SCHEMA = ‘Database-Name’ LIMIT 0 , 30 Advertisements