/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

1 vote182 views2 answers
Copy database mysql
SQL
15 votes174 views3 answers
Mysql update add to existing value
SQL
0 vote169 views1 answer
Fill up postgres db
SQL
1 vote176 views1 answer
Oracle sql average
SQL
0 vote178 views1 answer
Oracle sql copy table without data
SQL
0 vote165 views1 answer
Postgres select except
SQL
2 votes212 views1 answer
Oracle insert or update
SQL
1 vote176 views2 answers
Oracle list service names
SQL
1 vote161 views1 answer
Sql Split string function
SQL
0 vote221 views1 answer
SQL get max per id
SQL