To create triggers in PHPMyAdmin, click More at the top menu, click Triggers.
1) Click Add trigger
2) create a trigger name such as date trigger
3) input table name for your trigger in Table
4) Select Time from: Before, After
5) Select INSERT, UPDATE, DELETE
6) In Definition: for example, I want my CreateionDate column equal to current timing
BEGIN
SET NEW.CreationDate = NOW();
END
7) Definer: enter your your email address
No comments:
Post a Comment