get table which have specific columns in mysql

Solutions on MaxInterview for get table which have specific columns in mysql by the best coders in the world

showing results for - "get table which have specific columns in mysql"

1SELECT DISTINCT TABLE_NAME 
2    FROM INFORMATION_SCHEMA.COLUMNS
3    WHERE COLUMN_NAME IN ('columnA','ColumnB')
4        AND TABLE_SCHEMA='YourDatabase';

similar questions

mysql query select more columns mysql select multiple rows into one column mysql select all columns and specific fields as mysql get only the field names in a table mysql query to get column names mysql search for column name in all tables how to see which columns are indexxed mysql how to select multiple columns from different tables in mysql find a column in all tables mysql mysql get column names from table get the next column of a table in mysql mysql get fields of table mysql select all table that have field names search column by name mysql select from column mysql search mysql database for column querry mysql by 2 columns find how many table doesn 27t contain column in mysql show table columns mysql command line mysql select columns as string mysql to get column name in database how to select specific table data from an mysql databse server 3a set column in all row mysql mysql count multiple columns in one query list in one column mysql mysql all columns how to output a different column name in mysql

queries leading to this page

mysql search for column name in all tables my sql search column name mysql search column name in entire database mysql get table by name show tables mysql where table name find coulumn name in mysql db find a column in all tables mysql search for column name in mysql mysql seawrch tables for column name show all tables with column name mysql mysql describe table return only column names look columns of table in mysql find tables having column name mysql find table in mysql where column name mysql query to find column name in all tables mysql find table containing column mysql search column in database find specific column in all tables mysql how to search columns in mysql search column name in mysql mysql search database for one column name find column from all tables mysql different table names with one column in mysql search column in database mysql mysql get all tables with column name mysql select column names from database find column by name mysql mysql how to get specific column from table find column name in database mysql printing column name of value in mysql python mysql find table names mysql select all tables with column name like search for a particluar column in mysql mysql find tables with column name mysql find column name with table get column name from all tablesmysql find all tables with column name mysql mysql search database for column name mysql find all tables with field name find column in database mysql mysql find table with column name mysql select column name from all db find table name by column name in mysql sql search in all db column my sql mysql search for column in all tables mysql search field name in all tables find column name in mysql mysql search column name in all tables dispaly a search for a column in a table in mysql find column in all tables mysql mysql find field in all tables how to select specific columns in mysql mysql find tables by column name mysql select specific column find table by column name mysql sql search all column my sql mysql search all table find column name mysql query find field mysql find a column name in all tables mysql select all tables where column name how to get the column name from table in mysql php search field name in whole mysql databse mysql query to find column name in database mysql list all tables with column name mysql get all the names if they contain a mysql find columns by name how to find table name from column value in mysql mysql find column name in all tables query to check column name in all tables in mysql mysql search all tables for column name mysql find table by name mysql select solumn names from database mysql search table name by column how to find a column in all tables in mysql find tables with column name mysql mysql search a column name in whole database how to select specific columns mysql mysql field search mysql search table with column name search for column in all tables mysql mysql find column name in db mysql select specific columns find column name in mysql database mysql find table by column name mysql find all columns with name mysql select column from all tables mysql search database for column name mysql get tables with specific column mysql find table having column name mysql get tables with column name mysql search for field name in all tables mysql select specific column in 2 tables how to find table name from column value in mysql and show the records get specific column in mysql how to find column name in whole database in mysql mysql search cullumn in all tables get table which have specific columns in mysql