在插入和更新数据之前分别获取当前系统时间来更新 CREATE TRIGGER `trg_recruitment_source_insert` BEFORE INSERT ON `t_recruitment_source` FOR EACH ROW SET new.InsertTime = CURRENT_DATE; CREATE TRIGGER `trg_recruitment_source_update` BEFORE UPDATE ON `t_recruitment_source` FOR EACH ROW SET new.UpdateTime = CURRENT_DATE; 在navicat中如下填写即可