Triggers and Events.sql

#TRIGGERS 

SELECT * 
FROM employee_demographics;

SELECT * 
FROM employee_salary;

DELIMITER $$
CREATE TRIGGER trigger_1
		AFTER INSERT ON employee_salary
		FOR EACH ROW 
BEGIN
		INSERT INTO employee_demographics(employee_id, first_name, last_name)
        VALUES(NEW.employee_id, NEW.first_name, NEW.last_name);
END $$
DELIMITER ;

INSERT INTO employee_salary(employee_id, first_name, last_name, occupation, salary, dept_id)
VALUES
(
'13', 'Prajjwol', 'Thapa', 'Data Analyst', 200000, 3
); 


#EVENTS

SELECT * 
FROM employee_demographics;

DELIMITER $$
CREATE EVENT retires
ON SCHEDULE EVERY 30 SECOND
DO
BEGIN
    DELETE 
	FROM employee_demographics
	WHERE age >= 60;
END $$
DELIMITER ;