/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

-2 votes278 views2 answers
Add auto_increment column to existing table mysql
SQL
11 votes223 views1 answer
Reset identity sql server
SQL
0 vote232 views1 answer
Describe in sqlite3
SQL
0 vote261 views1 answer
Select amount weeks between two dates mysql
SQL
0 vote254 views1 answer
Oracle allow space to user
SQL
0 vote245 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
18 votes255 views4 answers
Uninstall mysql ubuntu 18.04
SQL
0 vote249 views1 answer
Ignore case in string sql
SQL
0 vote268 views3 answers
Fetlife
SQL
0 vote261 views1 answer
Mysql join only one column
SQL