/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 vote199 views1 answer
Oracle job schedules
SQL
1 vote212 views2 answers
Grab part of a string sql
SQL
0 vote216 views1 answer
Postgresql delete type
SQL
2 votes212 views1 answer
When matched in sql server
SQL
1 vote198 views4 answers
Between vs in sql
SQL
6 votes212 views3 answers
How to delete table sqlite
SQL
4 votes192 views1 answer
Mac install mysql
SQL
0 vote166 views1 answer
Online sql compiler
SQL
0 vote199 views1 answer
Data structures in sql
SQL
1 vote217 views3 answers
Java.sql.sqlexception: access denied for user
SQL