/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

1 vote144 views2 answers
Populate sql table with random data
SQL
0 vote164 views1 answer
Drop table BigQuery table columns
SQL
0 vote177 views1 answer
Mysql subtract month from timestamp
SQL
-1 vote142 views3 answers
SQL to LINQ converter
SQL
3 votes186 views1 answer
Oracle apex warn on unsaved changes
SQL
4 votes136 views1 answer
Create db table
SQL
1 vote133 views1 answer
How to delete data from sql database in android
SQL
3 votes193 views1 answer
Oracle function
SQL
0 vote140 views1 answer
Select other columns with distinct
SQL
0 vote151 views1 answer
Top 3 salary in sql
SQL