Database reference - sakila

sakila -  triggers -  ins_film

Description

none

Trigger properties

namevalue
parentfilm
typeINSERT
action order0
action orientationROW
action timingAFTER
action reference old rowOLD
action reference new rowNEW
sql modeSTRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER
definerroot@localhost

Dependency graph

filmfilm_textins_film

Objects that ins_film depends on

nameobject typelevel
film_texttable1

Code

BEGIN
    INSERT INTO film_text (film_id, title, description)
        VALUES (new.film_id, new.title, new.description);
  END



Documentation generated by SqlSpec