xxxxxxxxxx
DELIMITER $$
CREATE TRIGGER before_tabName_row_delete
BEFORE DELETE ON tabName
FOR EACH ROW
BEGIN
-- action, for example
SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Deleting from tabName is forbidden!';
END$$
DELIMITER ;
xxxxxxxxxx
SHOW TRIGGERS;
Code language: SQL (Structured Query Language) (sql)