/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 vote270 views1 answer
Add bool column in sql
SQL
0 vote257 views1 answer
How to save data in database in mysql node
SQL
0 vote269 views1 answer
Update view sql
SQL
0 vote280 views1 answer
Oracle remove line breaks
SQL
4 votes331 views4 answers
Check constraint in ms sql
SQL
7 votes285 views5 answers
Sql remove spaces
SQL
0 vote281 views1 answer
Alter rename command in mysql
SQL
0 vote230 views1 answer
'0000-00-00' for column '
SQL
1 vote260 views2 answers
Sql where is not number
SQL
0 vote270 views1 answer
Sql change date format
SQL