Virajsinh

MySQL Specific Delete And Update Record Prevent Using Trigger

Sep 12th, 2025
1,866
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.84 KB | Source Code | 0 0
  1. -- DELETE Restriction
  2. -- -----------------------------------------------------------------------
  3. DELIMITER //
  4.  
  5. CREATE TRIGGER prevent_delete_id_1
  6. BEFORE DELETE ON your_table
  7. FOR EACH ROW
  8. BEGIN
  9.   IF OLD.id = 1 THEN
  10.     SIGNAL SQLSTATE '45000'
  11.       SET MESSAGE_TEXT = 'Deletion of row with id = 1 is not allowed';
  12.   END IF;
  13. END//
  14.  
  15. DELIMITER ;
  16. -- -----------------------------------------------------------------------
  17. -- UPDATE Restriction
  18. -- -----------------------------------------------------------------------
  19. DELIMITER //
  20.  
  21. CREATE TRIGGER prevent_update_id_1
  22. BEFORE UPDATE ON your_table
  23. FOR EACH ROW
  24. BEGIN
  25.   IF OLD.id = 1 THEN
  26.     SIGNAL SQLSTATE '45000'
  27.       SET MESSAGE_TEXT = 'Update of row with id = 1 is not allowed';
  28.   END IF;
  29. END//
  30.  
  31. DELIMITER ;
  32. -- -----------------------------------------------------------------------
Tags: mysql
Advertisement
Add Comment
Please, Sign In to add comment