/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

9 votes147 views3 answers
Mysql run sql file
SQL
0 vote135 views1 answer
2020 new year
SQL
1 vote146 views1 answer
Install postgresql on raspberry pi
SQL
0 vote140 views2 answers
Create new table plsql
SQL
0 vote128 views1 answer
Change database name psql 8
SQL
0 vote136 views1 answer
Mariadb search columns
SQL
5 votes128 views2 answers
Umgebungsvariable setzen für mysql 8
SQL
0 vote127 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
18 votes135 views4 answers
Foreign key mySql
SQL
0 vote157 views1 answer
Excel vba import data to sql server
SQL