reenadak

Triggers for created and modified

Sep 25th, 2017
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.29 KB | None | 0 0
  1. DROP TRIGGER IF EXISTS `TBL_NAME_created`;
  2. CREATE TRIGGER `TBL_NAME_created` BEFORE INSERT ON `TBL_NAME`  FOR EACH ROW SET NEW.created = NOW();
  3.  
  4. DROP TRIGGER IF EXISTS `TBL_NAME_modified`;
  5. 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