Wednesday, August 20, 2014

Create triggers in PHPMyAdmin




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