sakila - upd

Description

none

Trigger properties

name	value
parent	film
type	UPDATE
action order	0
action orientation	ROW
action timing	AFTER
action reference old row	OLD
action reference new row	NEW
sql mode	STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER
definer	root@localhost

Dependency graph

filmfilm_textupd_film

Objects that upd_film depends on

name	object type	level
film_text	table	1

Code

BEGIN
    IF (old.title != new.title) or (old.description != new.description)
    THEN
        UPDATE film_text
            SET title=new.title,
                description=new.description,
                film_id=new.film_id
        WHERE film_id=old.film_id;
    END IF;
  END

sakila - triggers - upd_film

Description

Trigger properties

Dependency graph

Objects that upd_film depends on

Code