Quote
UNLOCK TABLES; -- -- WARNING: old server version. The following dump may be incomplete. -- DELIMITER ;; /*!50003 SET SESSION SQL_MODE="" */;; /*!50003 CREATE */ /*!50017 DEFINER=`mysql`@`localhost` */ /*!50003 TRIGGER `trg_author_dt` BEFORE INSERT ON `Authors` FOR EACH ROW SET NEW.Modified=NOW(), NEW.Creation=NOW() */;; DELIMITER ; -- -- WARNING: old server version. The following dump may be incomplete. -- DELIMITER ;; /*!50003 SET SESSION SQL_MODE="" */;; /*!50003 CREATE */ /*!50017 DEFINER=`mysql`@`localhost` */ /*!50003 TRIGGER `trg_author_md` BEFORE UPDATE ON `Authors` FOR EACH ROW SET NEW.modified=NOW() */;; DELIMITER ;
| Subject | Views | Written By | Posted |
|---|---|---|---|
| SHOW CREATE TRIGGER fails | 2025 | Steven Fullmer | 07/01/2011 05:42AM |
| Re: SHOW CREATE TRIGGER fails | 557 | Peter Brawley | 07/01/2011 10:59AM |
| Re: SHOW CREATE TRIGGER fails | 965 | Steven Fullmer | 07/01/2011 11:08AM |
| Re: SHOW CREATE TRIGGER fails | 582 | Peter Brawley | 07/01/2011 11:25AM |
| Re: SHOW CREATE TRIGGER fails | 542 | Steven Fullmer | 07/01/2011 11:34AM |
| Re: SHOW CREATE TRIGGER fails | 532 | Peter Brawley | 07/01/2011 12:27PM |
| Re: SHOW CREATE TRIGGER fails | 567 | Steven Fullmer | 07/01/2011 12:33PM |
| Re: SHOW CREATE TRIGGER fails | 527 | Peter Brawley | 07/01/2011 12:42PM |
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.