/SQL/Find how many table doesn't contain column in mysql

Find how many table doesn't contain column in mysql

select
t.*
from INFORMATION_SCHEMA.TABLES as t
    left join INFORMATION_SCHEMA.COLUMNS as c
    on c.TABLE_NAME = t.TABLE_NAME
    and c.TABLE_SCHEMA = t.TABLE_SCHEMA
    and c.COLUMN_NAME = 'unique'
where c.COLUMN_NAME is null
and t.TABLE_SCHEMA = 'database'

Source: stackoverflow.com

Similar codes

0 vote182 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
0 vote195 views1 answer
What is ssrs and ssis in sql server
SQL
4 votes203 views2 answers
Sql server date now
SQL
0 vote189 views1 answer
SQL Error 1040 : Too many connections
SQL
5 votes188 views2 answers
Oracle tables with column name
SQL
0 vote180 views1 answer
Python mysql query where
SQL
0 vote191 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
0 vote188 views1 answer
Sql server delete records with specific date
SQL
6 votes181 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
0 vote240 views1 answer
Pl sql join 3 tables
SQL