mysql摘记

SHOW FUNCTION STATUS WHERE Db = 'chasepaydb';

SELECT ROUTINE_NAME AS `Procedure` FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA = 'chasepaydb' AND ROUTINE_TYPE = 'PROCEDURE';


SHOW VARIABLES LIKE 'event_scheduler' ; 

SHOW VARIABLES LIKE 'event_scheduler';


SELECT * FROM mysql.event;

SHOW CREATE EVENT day_trannumber_event;
SHOW CREATE EVENT hour_trannumber_event;

SHOW WARNINGS;

SHOW EVENTS ;