example: using a trigger to backup deleted records


CREATE TRIGGER `databasename`.`saveDeletedRecs`

BEFORE DELETE ON `databasename`.`ex_tbl_trgr`
FOR EACH ROW

BEGIN
             INSERT INTO ex_tbl_trgr_bkp (`id`,`name`,`company`)
             VALUES(OLD.id,OLD.name,OLD.company) ;
END //

code -------------------> demo