USE information_schema; SELECT o.TABLE_SCHEMA, o.UPDATE_TIME FROM `TABLES` o LEFT JOIN `TABLES` b ON o.TABLE_SCHEMA = b.TABLE_SCHEMA AND o.UPDATE_TIME < b.UPDATE_TIME WHERE b.UPDATE_TIME IS NULL AND o.UPDATE_TIME IS NOT NULL GROUP BY o.TABLE_SCHEMA;
My Notebook
USE information_schema; SELECT o.TABLE_SCHEMA, o.UPDATE_TIME FROM `TABLES` o LEFT JOIN `TABLES` b ON o.TABLE_SCHEMA = b.TABLE_SCHEMA AND o.UPDATE_TIME < b.UPDATE_TIME WHERE b.UPDATE_TIME IS NULL AND o.UPDATE_TIME IS NOT NULL GROUP BY o.TABLE_SCHEMA;