Check out example codes for "find how many table doesn't contain column in mysql". It will help you in understanding the concepts better.
Code Example 1
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'
Learn ReactJs, React Native from akashmittal.com