Find a column in all tables mysql

Mysql find tables with column name

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

Source: stackoverflow.com

Find a column in all tables mysql

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

Source: stackoverflow.com

Similar codes

2 votes190 views1 answer
How to select first row of database sql
SQL
3 votes209 views2 answers
Tsql join multiple record in one string
SQL
2 votes263 views1 answer
How to check grants on a package in oracle
SQL
0 vote217 views1 answer
How convert into in in sql query
SQL
1 vote202 views1 answer
Decalre temp table sql
SQL
0 vote210 views1 answer
Mysql type for large numbers with many decimal
SQL
2 votes193 views1 answer
Wait delay in sql server
SQL
0 vote188 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
0 vote217 views1 answer
Show table structure mysql console
SQL
0 vote213 views1 answer
Savepoint mysql script
SQL