/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

14 votes125 views4 answers
Import database through command line
SQL
0 vote108 views1 answer
Update having mysql
SQL
1 vote125 views1 answer
Join to find results not in another table
SQL
0 vote123 views1 answer
Mysql beautifier terminla
SQL
2 votes150 views1 answer
Mysql now format
SQL
1 vote113 views1 answer
Data type and their numeric form
SQL
0 vote132 views4 answers
Rownum in sql
SQL
25 votes157 views5 answers
Mysql replace text
SQL
0 vote119 views1 answer
Postgres truncate with cascade
SQL
0 vote155 views1 answer
Error code 1215 cannot add foreign key constraint
SQL