/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

14 votes317 views5 answers
Set password for postgres user ubuntu
SQL
0 vote307 views1 answer
Check command
SQL
0 vote305 views1 answer
Nvl2 syntax
SQL
1 vote305 views1 answer
Dropping a constraint in ms sql
SQL
0 vote311 views1 answer
Mysql delete entire row on condition
SQL
3 votes272 views5 answers
Mysql get last inserted id
SQL
0 vote277 views1 answer
Sql clear table
SQL
0 vote278 views1 answer
Inserted row count tsql
SQL
1 vote286 views1 answer
Oracle apex version view
SQL
0 vote293 views1 answer
Laravel migration sql dump
SQL