/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 vote325 views1 answer
How to Remove milliseconds from Date time
SQL
0 vote329 views1 answer
Flush user resource mysql
SQL
5 votes334 views1 answer
AND OR NOT operators sql
SQL
0 vote312 views1 answer
Truncate a table then insert data
SQL
0 vote293 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
0 vote354 views1 answer
What is delimiter in mysql
SQL
3 votes342 views2 answers
Mysql update row
SQL
1 vote302 views1 answer
Postgres regex remove special characters
SQL
0 vote331 views1 answer
Example database query
SQL
0 vote310 views1 answer
Groupby error in mysql
SQL