/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 vote328 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
0 vote351 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
0 vote332 views1 answer
Sql select non unique
SQL
5 votes384 views1 answer
Sql integer to serial
SQL
0 vote377 views1 answer
Doctors appointment
SQL
0 vote327 views1 answer
Oracle create package body
SQL
0 vote346 views2 answers
Getting customers with no orders sql
SQL
0 vote309 views2 answers
Influxdb delete measurement based on date
SQL
0 vote372 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL
0 vote350 views1 answer
Function sum(text) does not exist postgres
SQL