MYSQL觸發器 for 5.01

建立

CREATE  TRIGGER 觸發器名 AFTER INSERT ON 表  FOR EACH ROW

begin

insert into state_pro_update set
pid = New.id,
Operation = 'N';
end;

 

動作時間

BEFORE或AFTER 

動作

 INSERT,UPDATE, DELETE.

對應ROW

INSERT   >  New.obj

DELETE  >  Old.obj

UPDATE >  兩都都可 

 

定義變數

DECLARE isHave INT;

賦值

set isHave=0;

 

流程結構

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;