All pastes #419587 Raw Edit

Triggers for datetim

public text v1 · immutable
·published 2007-04-01 13:25 UTC
rendered paste body
DELIMITER $$

DROP TRIGGER `tablename_bi`$$

CREATE TRIGGER `tablename_bi` BEFORE INSERT ON `patients_notes`

	FOR EACH ROW BEGIN

	SET NEW.inserted = ifnull(NEW.inserted, now());

	SET NEW.insertedby = ifnull(NEW.insertedby, username());

	END$$

DELIMITER ;