/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 vote199 views1 answer
Mysql subdate
SQL
0 vote206 views1 answer
SQL Server modify_timestamp trigger
SQL
0 vote204 views1 answer
How to insert a uniqueidentifier in sql
SQL
0 vote206 views1 answer
How to find total working hour in sql
SQL
1 vote198 views3 answers
Mysql disable foreign keys check
SQL
0 vote211 views1 answer
Install package for sqlserver in asp.net core
SQL
0 vote220 views1 answer
How to select even id in sql
SQL
0 vote197 views1 answer
Split string by comma in sql server
SQL
0 vote198 views1 answer
Python sql last insertend
SQL
0 vote198 views1 answer
Left join in codeigniter query builder
SQL