Mysql Base events (scheduled tasks)
1. Ordinary events: execute the statement directly:
DROP EVENT IF EXISTS job_insertgood
DELIMITER $$
CREATE EVENT job_insertgood
ON SCHEDULE EVERY 10 SECOND
DO
BEGIN
INSERT INTO goods (name,num) VALUES (now (), 1)
END$$
DELIMITER
Second, events: calling stored procedures
DROP EVENT IF EXISTS job_callProcedure
DELIMITER $$
CREATE EVENT job_callProcedure
ON SCHEDULE EVERY 10 SECOND
DO
BEGIN
CALL procedureName ()
END$$
DELIMITER
3. Enable events (scheduled tasks):
1. View
SELECT @ @ event_scheduler
Or
SHOW VARIABLES LIKE 'event%'
2. Set up:
Set GLOBAL event_scheduler = 1
Or
SET GLOBAL event_scheduler = ON
