/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

4 votes190 views3 answers
Sqlite show columns
SQL
0 vote161 views2 answers
Mysql output csv
SQL
2 votes178 views2 answers
Sqlalchemy return id after insert
SQL
1 vote173 views1 answer
Search for tables with name postgresql
SQL
0 vote172 views3 answers
Drop multiple columns in sql
SQL
0 vote223 views1 answer
Mysql multiple group by
SQL
7 votes205 views1 answer
Show line number in sql server
SQL
0 vote188 views1 answer
Datagrip exec
SQL
0 vote172 views1 answer
Cast float mysql
SQL
0 vote136 views1 answer
Copy data from cell to cell mysql
SQL