/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 vote257 views1 answer
Oracle index partition
SQL
4 votes261 views1 answer
Mysql timestamp in laravel migration
SQL
0 vote252 views1 answer
How to avoid duplicate records in sqlite
SQL
0 vote213 views1 answer
Mysql collation for all languages
SQL
1 vote280 views1 answer
Postgresql not in
SQL
0 vote266 views1 answer
Hibernate xml property MySQL url, username and password
SQL
1 vote207 views1 answer
File /etc/init.d/mysql not exists
SQL
1 vote280 views1 answer
Cross schema query oracle 2 users
SQL
11 votes276 views1 answer
Oracle view source
SQL
1 vote272 views1 answer
Mysql check string don't have number
SQL