/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 vote183 views1 answer
One table with another
SQL
0 vote180 views1 answer
How to select only a certain date sql
SQL
-2 votes185 views1 answer
Create trigger syntax
SQL
-1 vote278 views5 answers
Left join sql
SQL
0 vote172 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
10 votes176 views5 answers
Create table mysql query
SQL
0 vote236 views1 answer
Postgres foreign key multiple columns
SQL
1 vote179 views1 answer
Oracle rolling back transactions
SQL
0 vote169 views1 answer
RowDataPacket
SQL
5 votes246 views1 answer
Migrate sql table another database
SQL