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'