DELIMITER |
 
CREATE TRIGGER created_date_treatment BEFORE INSERT
    ON cmdate FOR EACH ROW
BEGIN
  SET NEW.created_datetime = SYSDATE(), NEW.modified_datetime = SYSDATE();
END;

|

CREATE TRIGGER modified_date_treatment BEFORE UPDATE
    ON cmdate FOR EACH ROW
BEGIN
  SET NEW.modified_datetime = SYSDATE();
END;
 
|
 
DELIMITER ;