Sunday, 22 February 2015

MySQL Events

SET GLOBAL event_scheduler = ON;
SELECT @@event_scheduler ;
SHOW PROCESSLIST ;
SHOW EVENTS FROM Stick ;
SHOW CREATE EVENT Stick.EventAnalyticsGatherer ;

Monday, 9 February 2015

Finding cross references (from foreign keys)

SELECT *
FROM
  information_schema.KEY_COLUMN_USAGE
WHERE
  REFERENCED_TABLE_NAME = 'GameCompany'
  AND REFERENCED_COLUMN_NAME = 'Id'
  AND TABLE_SCHEMA = 'Stick';