mysql - Compare 2 database -


I have 2 identical database abc15 and abc18 but there is an extra table in one of the databases and i have to find out. I thought the following question should be returned, but it is not showing the record which I hope. Select info_schema.tables from info_schema.tables

  as.TABLE_SCHEMA = B.TABLE_SCHEMA and a.TABLE_NAME = b.TABLE_NAME on info_schema.tables b where a.TABLE_SCHEMA = 'abc15 'And B. TABLE_SCHEMA =' abc18 'and b.TABLE_NAME are NULL  

  $ Mysqldumpslow - Database abc15 & gt; / Tmp / a $ mysqldumpslow - Database abc18 & gt; / Tmp / b $ diff / tmp / a / tmp / b  

Comments