/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 vote111 views1 answer
Safe mysql
SQL
3 votes147 views2 answers
Check data in table mysql
SQL
0 vote112 views1 answer
Codeigniter dbforge add index
SQL
1 vote116 views1 answer
Psql client write to bash variable
SQL
0 vote114 views1 answer
Sql query interview questions githu
SQL
0 vote114 views1 answer
Template MySQL Zabbix agent
SQL
2 votes124 views2 answers
Mysql write into table
SQL
0 vote111 views1 answer
Why mysql is used?
SQL
0 vote121 views1 answer
Big table in mysql
SQL
0 vote274 views2 answers
Zsh: command not found: mysq
SQL