/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 vote566 views3 answers
Sql subquery
SQL
4 votes349 views2 answers
Postgres update single column
SQL
1 vote325 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
0 vote345 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
0 vote363 views1 answer
Difference between min and max date sql
SQL
0 vote365 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
0 vote321 views1 answer
How many columns can be used for creating index?
SQL
1 vote360 views1 answer
Oracle drop job if exists
SQL
11 votes355 views2 answers
Insert current date sql
SQL
2 votes374 views3 answers
Sql server reseed identity column
SQL