gtallen1187
10/3/2014 - 2:20 AM

find all DB changes within last 5 minutes

find all DB changes within last 5 minutes

SELECT
	CONCAT(TABLE_SCHEMA, '.', TABLE_NAME) AS 'Table',
	UPDATE_TIME AS 'Updated'
FROM INFORMATION_SCHEMA.TABLES
WHERE DATE_SUB(NOW(), INTERVAL 5 Minute) < UPDATE_TIME AND TABLE_SCHEMA != 'INFORMATION_SCHEMA' AND TABLE_TYPE = 'BASE TABLE'