用触发器来记录操作记录 直接上代码DROP TRIGGER IF EXISTS `trigger_book` ; DELIMITER $$ CREATE DEFINER=`root`@`%` TRIGGER trigger_book after update ON book FOR EACH ROW BEGIN declare nowtime int(11); set @b1 =''; set nowtime=unix_timestamp(now()); if (old.cooperation!=new.cooperation or new.base!=old.base or new.buyout!=old.buyout or new.into!=old.into or new.quan!=old.quan) then if (old.cooperation!=new.cooperation) then set @b1=concat(" 修改签约类型为：",new.cooperation," 旧值：",old.cooperation); end if; if (new.base!=old.base) then set @b1=concat(@b1," 修改保底为：",new.base," 旧值：",old.base); end if; if (new.buyout!=old.buyout) then set @b1=concat(@b1," 修改买断为：",new.buyout," 旧值：",old.buyout); end if; if (new.quan!=old.quan) then set @b1=concat(@b1," 修改全勤为：",new.quan," 旧值：",old.quan); end if; if (new.`into`!=old.`into`) then set @b1=concat(@b1," 修改分成为：",new.`into`," 旧值：",old.`into`); end if; insert into opt_log(opt_uid,opt_value,opt_time,bid)value(new.opt_uid,@b1,nowtime,new.id); end if; end $$# DELIMITER ; 以上是修改书的签约类型时，记录对应的人以及对应的修改前后的值。可能应用场景有限，但是这不需要在应用层去做相关功能， 直接数据库里就完事了。如果感兴趣还可以看看函数的应用