Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- DELETE Restriction
- -- -----------------------------------------------------------------------
- DELIMITER //
- CREATE TRIGGER prevent_delete_id_1
- BEFORE DELETE ON your_table
- FOR EACH ROW
- BEGIN
- IF OLD.id = 1 THEN
- SIGNAL SQLSTATE '45000'
- SET MESSAGE_TEXT = 'Deletion of row with id = 1 is not allowed';
- END IF;
- END//
- DELIMITER ;
- -- -----------------------------------------------------------------------
- -- UPDATE Restriction
- -- -----------------------------------------------------------------------
- DELIMITER //
- CREATE TRIGGER prevent_update_id_1
- BEFORE UPDATE ON your_table
- FOR EACH ROW
- BEGIN
- IF OLD.id = 1 THEN
- SIGNAL SQLSTATE '45000'
- SET MESSAGE_TEXT = 'Update of row with id = 1 is not allowed';
- END IF;
- END//
- DELIMITER ;
- -- -----------------------------------------------------------------------
Advertisement
Add Comment
Please, Sign In to add comment