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;