/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 vote406 views2 answers
Mysql insert rows to another database
SQL
0 vote356 views1 answer
How to select only a certain date sql
SQL
0 vote346 views1 answer
Returning with sqlalchemy
SQL
0 vote370 views2 answers
Mysql missin expression near on
SQL
0 vote319 views1 answer
Postpresql relation not found
SQL
0 vote358 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
23 votes339 views3 answers
Mysqldump
SQL
1 vote318 views1 answer
Delete mysql from mac
SQL
1 vote298 views1 answer
Enable mysql slow query log
SQL
7 votes333 views6 answers
Group_concat mysql
SQL