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

1 vote213 views1 answer
Mysql monthname
SQL
1 vote247 views1 answer
Find size of all DB's postgres
SQL
1 vote248 views2 answers
Postgres select from last 3 months
SQL
0 vote225 views1 answer
Sql query use select name inside where clause
SQL
0 vote212 views1 answer
Jooq replace
SQL
0 vote228 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
1 vote211 views1 answer
How much every mysql database record takes from diskspace
SQL
0 vote213 views1 answer
Mysql add to value
SQL
2 votes228 views1 answer
Oracle sql merge
SQL
18 votes208 views3 answers
Mysql query add column with default string value
SQL