time-trigger-mysql

# ref : https://www.mysqltutorial.org/mysql-triggers/working-mysql-scheduled-event/
#1.Check event_scheduler = on or Active event_scheduler
SET GLOBAL event_scheduler = ON;
use test;
show processlist;
show events;
#2.Creating new MySQL events
#create table for test
drop table if exists test.messages;
CREATE TABLE test.messages (
    id INT AUTO_INCREMENT primary key,
    message VARCHAR(255) NOT NULL,
    created_at DATETIME NOT NULL
);


#3.Create EVENT schedule
#3.1
drop event IF EXISTS test_event_01;
CREATE EVENT IF NOT EXISTS test_event_01
ON SCHEDULE AT CURRENT_TIMESTAMP
DO
  INSERT INTO messages(message,created_at)
  VALUES('Test MySQL Event 1',NOW());
#3.2
drop event IF EXISTS test_event_02;
CREATE EVENT IF NOT EXISTS test_event_02
ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 MINUTE
ON COMPLETION PRESERVE
DO
   INSERT INTO messages(message,created_at)
   VALUES('Test MySQL Event 2',NOW());
#3.3
drop event IF EXISTS test_event_03;
CREATE EVENT test_event_03
ON SCHEDULE EVERY 1 MINUTE
STARTS CURRENT_TIMESTAMP
ENDS CURRENT_TIMESTAMP + INTERVAL 1 HOUR
DO
   INSERT INTO messages(message,created_at)
   VALUES('Test MySQL recurring Event',NOW());

show events from classicmodels;