Public feed #2128278

Someone

public text v1 · immutable
Raw Edit
·published 2012-03-15 01:10 UTC
rendered paste body
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 ;