Answers for "mysql show all tables with column name"

mysql show all tables

show tables;

Posted by: Guest on March-19-2020

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';

Posted by: Guest on April-08-2021

Code answers related to "mysql show all tables with column name"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "mysql show all tables with column name"

Code answers related to "mysql show all tables with column name"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "mysql show all tables with column name"

Code answers related to "mysql show all tables with column name"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us