/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 vote195 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
0 vote146 views1 answer
Check sql query executed wp
SQL
0 vote204 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
1 vote197 views1 answer
Sqlalchemy order by descending
SQL
0 vote192 views1 answer
C# add a textbox in mysql select
SQL
0 vote214 views1 answer
Mysql value ends with
SQL
2 votes191 views2 answers
Get all tables using like
SQL
5 votes228 views2 answers
Create table mysql example auto_increment
SQL
0 vote186 views1 answer
Sql server convert date to weekday
SQL
0 vote245 views3 answers
Mysql keyword search
SQL