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 vote207 views1 answer
Sql into vs insert into
SQL
0 vote207 views1 answer
SQL Error 1040 : Too many connections
SQL
4 votes242 views2 answers
Insert current date in mysql
SQL
1 vote188 views1 answer
User privileges postgresql information_schema
SQL
4 votes215 views2 answers
REST API
SQL
0 vote287 views1 answer
Mysql get nested records
SQL
0 vote229 views1 answer
Split first name and last name in sql
SQL
0 vote217 views1 answer
How to run mysql on terminal mac
SQL
32 votes236 views6 answers
Rename column mysql
SQL
21 votes161 views7 answers
Table drop if exist sql server
SQL