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