/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

12 votes365 views4 answers
Mysql get date difference in hours
SQL
0 vote382 views3 answers
Remove folders from remote git
SQL
0 vote361 views2 answers
Reseed sql identity
SQL
6 votes352 views2 answers
Mysql version check cmd
SQL
3 votes381 views1 answer
Postgresql today - 1 year
SQL
0 vote367 views2 answers
PostgreSQL having
SQL
0 vote400 views1 answer
Psql check if sql script is valid
SQL
2 votes365 views2 answers
How to check data type in sql server
SQL
0 vote384 views1 answer
Oracle locked objects
SQL
1 vote347 views1 answer
Not exists mysql
SQL