tLpctHDe

1DROP DATABASE IF EXISTS demo;
2CREATE DATABASE demo;
3USE demo;
4SET GLOBAL event_scheduler = ON;
5CREATE TABLE people(
6ID INT AUTO_INCREMENT PRIMARY KEY,
7name VARCHAR(50) NOT NULL,
8age INT NOT NULL,
9birth_date DATE NOT NULL);
10
11INSERT INTO people (name, age, birth_date)
12VALUES ('Keanu Reeves', 53, '1964-05-01');
13
14DROP EVENT IF EXISTS age_update;
15DELIMITER ^^
16CREATE EVENT age_update 
17ON SCHEDULE EVERY 10 SECOND
18DO
19BEGIN
20UPDATE people
21SET age = age +1
22WHERE age < (YEAR(NOW()) - YEAR(birth_date));
23END
24^^
25DELIMITER ;
26SELECT *
27FROM people;