/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 vote240 views1 answer
Ansi sql count duplicate rows
SQL
0 vote168 views1 answer
Check if due date is less than todays date sql
SQL
5 votes207 views1 answer
Sql first day of current year
SQL
6 votes207 views1 answer
What is where clause in sql
SQL
0 vote208 views1 answer
Oracle right characters
SQL
2 votes222 views1 answer
Postgresql transaction
SQL
0 vote229 views1 answer
Mysql limit order by
SQL
11 votes228 views4 answers
Update row in mysql
SQL
0 vote241 views1 answer
Remove mysql from centos 7
SQL
2 votes211 views1 answer
Sqlite indexes
SQL