MySQL trigger for 5.01

Create

Create trigger name after insert on table for each row

Begin

Insert into state_pro_update set
PID = new. ID,
Operation = 'n ';
End;

 

Action time

Before or after

Action

Insert, update, delete.

Corresponding row

Insert> New. OBJ

Delete> old. OBJ

Update> both are available.

 

Define Variables

Declare ishave int;

Assignment

Set ishave = 0;

 

Process Structure

If ishave = 1 then

....

Else if not exists (select * from test form ID = 88) then

....

Else

....

End if;

 

[begin_label:] WHILE search_condition DO

    statement_list

END WHILE [end_label]

 

Case ishave

When 0 then ....

When 1 then ....

End case;