Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP TRIGGER IF EXISTS `TBL_NAME_created`;
- CREATE TRIGGER `TBL_NAME_created` BEFORE INSERT ON `TBL_NAME` FOR EACH ROW SET NEW.created = NOW();
- DROP TRIGGER IF EXISTS `TBL_NAME_modified`;
- CREATE TRIGGER `TBL_NAME_modified` BEFORE UPDATE ON `TBL_NAME` FOR EACH ROW SET NEW.modified = NOW();
Add Comment
Please, Sign In to add comment