CREATE TABLE `MyTable` (`MyTable_ID` int UNSIGNED NOT NULL AUTO_INCREMENT ,`MyData` varchar(10) NOT NULL ,`CreationDate` datetime NULL ,`UpdateDate` datetime NULL ,PRIMARY KEY (`MyTable_ID`));
CREATE TRIGGER `MyTable_INSERT` BEFORE INSERT ON `MyTable`FOR EACH ROW BEGIN-- Set the creation dateSET new.CreationDate = now();
-- Set the udpate dateSet new.UpdateDate = now();END;
CREATE TRIGGER `MyTable_UPDATE` BEFORE UPDATE ON `MyTable`FOR EACH ROW BEGIN-- Set the udpate dateSet new.UpdateDate = now();END;
DELIMITER //CREATE TRIGGER `MyTable_UPDATE` BEFORE UPDATE ON `MyTable`FOR EACH ROW BEGIN-- Set the udpate dateSet new.UpdateDate = now();END//DELIMITER ;
/************ ROLE ************/drop table if exists `role`;create table `role` (`id_role` bigint(20) unsigned not null auto_increment,`date_created` datetime,`date_deleted` datetime,`name` varchar(35) not null,`description` text,primary key (`id_role`)) comment='';
drop trigger if exists `role_date_created`;create trigger `role_date_created` before inserton `role`for each rowset new.`date_created` = now();