Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

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 by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #find #column #tables #mysql
ADD COMMENT
Topic
Name
7+9 =