visabhishek · February 6, 2016 12:00
diff --git a/Avoide_delete_trigger_mysql.php b/Avoide_delete_trigger_mysql.php
 DELIMITER $$

 CREATE TRIGGER trigger1
 BEFORE DELETE
 ON table1
 FOR EACH ROW
 BEGIN
  IF OLD.id = 1 THEN -- Abort when trying to remove this record
    CALL cannot_delete_error; -- raise an error to prevent deleting from the table
  END IF;
 END
 $$

 DELIMITER ;
	DELIMITER $$

	CREATE TRIGGER trigger1
	BEFORE DELETE
	ON table1
	FOR EACH ROW
	BEGIN
	IF OLD.id = 1 THEN -- Abort when trying to remove this record
	CALL cannot_delete_error; -- raise an error to prevent deleting from the table
	END IF;
	END
	$$

	DELIMITER ;