/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
Sql case when exists in another table
SQL
0 vote320 views1 answer
Sql decode
SQL
5 votes335 views1 answer
Oracle asynchronous update
SQL
0 vote371 views3 answers
Mysql CAST(amount as float)
SQL
0 vote347 views1 answer
Migration graphql
SQL
0 vote330 views1 answer
Postgres type equivalent to timespan c#
SQL
0 vote315 views1 answer
How to check default value of column in sql server
SQL
-1 vote337 views5 answers
Operator in sql
SQL
9 votes329 views5 answers
Sql limit
SQL
0 vote367 views1 answer
Check constraint is violated
SQL