[[poliburro]]

Código SQL [-]
 
CREATE TRIGGER prueba BEFORE UPDATE ON td_persona
FOR EACH ROW
BEGIN
  DECLARE @maximo int(11);
  SET @maximo =(SELECT MAX(audi_id) FROM ts_auditoria);
  if(OLD.pers_rut <> :NEW.pers_rut)then
     begin
        INSERT INTO ts_auditoria 
        VALUES(@maximo,'255.255.255.0',(DATE_FORMAT(now(),'%Y/%m/%d')),'td_persona','pers_rut',:OLD.pers_rut,:NEW.pers_rut);
     end;
  if(:OLD.pers_dv <> :NEW.pers_dv)then
     begin
         INSERT INTO ts_auditoria 
         VALUES(@maximo,'255.255.255.0',(DATE_FORMAT(now(),'%Y/%m/%d')),'td_persona','pers_dv',:OLD.pers_dv,:NEW.pers_dv);
     end;
END;