Triggers

Name

upd_film

Owner

DEFINER

Action Timing

AFTER

Event Manipulation

UPDATE

Body

BEGIN IF (old.title != new.title) 
OR (
  old.description != new.description
) 
OR (old.film_id != new.film_id) 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

Table Name

film

Triggers

Change your password

Change password for user ''