DELIMITER | DROP TRIGGER test| CREATE TRIGGER test BEFORE DELETE ON clients FOR EACH ROW BEGIN DECLARE tmp INT(2) DEFAULT (SELECT MAX(idevent) FROM events); DECLARE idcli INT(2) DEFAULT OLD.idclient; SET @max=tmp+1; INSERT INTO events VALUES(@max, idcli); END;| DELIMITER ;