/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 vote324 views1 answer
Mysql change default collation
SQL
49 votes382 views6 answers
Install mysql ubuntu
SQL
0 vote302 views1 answer
Why we have to set the password for my sql server
SQL
20 votes349 views4 answers
Sql count if
SQL
0 vote306 views1 answer
Find duplicate users by email address in mysql
SQL
1 vote312 views1 answer
Oracle sql pad left zeros
SQL
0 vote305 views4 answers
Postgresql between month
SQL
0 vote337 views1 answer
Sql values that contains certain multiple ids
SQL
-1 vote285 views3 answers
Mysql get age from date
SQL
0 vote291 views1 answer
Call procedure in wordpress
SQL