Database reference - sakila

sakila -  triggers -  customer_create_date

Description

none

Trigger properties

namevalue
parentcustomer
typeINSERT
action order0
action orientationROW
action timingBEFORE
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

customercustomer_create_date

Objects that customer_create_date depends on

nameobject typelevel

Code

SET NEW.create_date = NOW()



Documentation generated by SqlSpec