DELIMITER ;; CREATE TRIGGER `messagelists` BEFORE`messagelists` UPDATE ON `messagelists` FOR EACH ROW BEGIN SET NEW.messagedate = NOW(); END;; DELIMITER ;