/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 vote147 views1 answer
Datagrip execute procedure
SQL
0 vote148 views1 answer
Rollback to name in sql
SQL
0 vote144 views1 answer
Mysql update privileges
SQL
0 vote142 views1 answer
Mysql zerofill
SQL
2 votes140 views3 answers
Row number mysql
SQL
0 vote132 views4 answers
Sql year
SQL
27 votes258 views3 answers
Mysql delete row
SQL
0 vote146 views1 answer
Sqlite get date only
SQL
0 vote151 views1 answer
Mysql enter ubuntu
SQL
2 votes173 views1 answer
Dbms transaction (psql)
SQL