/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 vote194 views1 answer
Tsql delete all rows
SQL
-1 vote197 views1 answer
Sql show custom constraints
SQL
-1 vote149 views10 answers
Delete Query in SQL Server
SQL
0 vote191 views1 answer
Postgres reorder columns
SQL
1 vote171 views2 answers
Mysql does sentance contain word
SQL
0 vote174 views1 answer
Oracle list of long running queries
SQL
1 vote178 views1 answer
Import sql file mysql commadn line
SQL
0 vote184 views1 answer
Oracle exchange partition
SQL
0 vote201 views1 answer
T sql dynamic top n query
SQL
0 vote181 views1 answer
MySQL - How to find word with the most similar beginning
SQL