如何在@SQL列上每隔一年指数增加一次工资

CREATE TABLE employees (
  id INT PRIMARY KEY,
  name VARCHAR(50),
  salary DECIMAL(10, 2),
  hire_date DATE
);

CREATE TRIGGER increase_salary
BEFORE INSERT ON employees
FOR EACH ROW
BEGIN
  DECLARE years_passed INT;
  SET years_passed = TIMESTAMPDIFF(YEAR, NEW.hire_date, CURDATE());
  
  IF years_passed > 0 AND years_passed % 1 = 0 THEN
    SET NEW.salary = NEW.salary * POWER(1.1, years_passed);
  END IF;
END;

INSERT INTO employees (id, name, salary, hire_date)
VALUES (1, 'John Doe', 5000, '2020-01-01');