/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 vote155 views1 answer
Mysql current running queries
SQL
0 vote125 views2 answers
Identity syntax in sql
SQL
-1 vote125 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
0 vote151 views1 answer
Mysql grant user wildcard database
SQL
0 vote196 views1 answer
Bigrock database connection string
SQL
1 vote168 views1 answer
Insert pg result of select
SQL
1 vote91 views1 answer
Import in mysql without a software
SQL
3 votes118 views1 answer
Oracle APEX elapsed time
SQL
0 vote154 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
0 vote114 views1 answer
Case insensitive sql
SQL