Breaking News: Grepper is joining You.com. Read the official announcement!

Creating a Before Update Trigger

Uptight Unicorn answered on March 10, 2022 Popularity 4/10 Helpfulness 7/10

answer Creating a Before Update Trigger

related trigger before update

Creating a Before Update Trigger

Comment

DELIMITER $$

CREATE TRIGGER product_name_validator

BEFORE UPDATE

ON products FOR EACH ROW

IF NEW.product_name<>OLD.product_name

THEN

SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Product name is read-only and it can not be changed.';

END IF $$

DELIMITER ;

Popularity 4/10 Helpfulness 7/10 Language sql

Source: www.linode.com

Tags: sql

Link to this answer
Share Copy Link

Contributed on Oct 14 2023

Uptight Unicorn

0 Answers Avg Quality 2/10

Closely Related Answers

trigger before update

Comment

DELIMITER $$

CREATE TRIGGER trigger_name
    BEFORE UPDATE
    ON table_name FOR EACH ROW
BEGIN
    -- statements
END$$    

DELIMITER ;
Code language: SQL (Structured Query Language) (sql)

Popularity 7/10 Helpfulness 1/10 Language css

Source: www.mysqltutorial.org

Tags: css

Link to this answer
Share Copy Link