MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Albums (
  `owner` INTEGER
);
CREATE TRIGGER ownerChange
    BEFORE UPDATE ON Albums
    FOR EACH ROW
    BEGIN
        -- owner is a column of the Albums table
        IF (NEW.owner <> OLD.owner) THEN
            -- Our textbook mentions using "RAISE_APPLICATION_ERROR",
            -- but the darn book is 20 years old, and Googling suggests
            -- using SIGNAL instead.
            SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Changing album owner is not allowed.';
        END IF;
    END
INSERT INTO Albums VALUES (1);
UPDATE Albums SET owner = 2 WHERE owner = 1;
Changing album owner is not allowed.

SELECT * FROM Albums;


owner


1