/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 vote191 views3 answers
Characters found after end of sql statement
SQL
0 vote176 views1 answer
Running percentage of total postgres
SQL
2 votes175 views1 answer
Sql server case sensitive search
SQL
0 vote163 views1 answer
List column names of multiple tables psql
SQL
0 vote178 views1 answer
Create table split string function in sql server
SQL
0 vote166 views1 answer
Mysql query to add hours to column in table
SQL
1 vote161 views2 answers
Sql convert datetime to year month
SQL
0 vote178 views1 answer
Postgresql list extensions
SQL
0 vote170 views1 answer
Mysql installer no packages found
SQL
0 vote163 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL