MYSQL 触发器 for 5.01

建立
CREATE TRIGGER 触发器名 AFTER INSERT ON 表 FOR EACH ROW
begin
insert into state_pro_update setpid = 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_listEND WHILE [end_label]

case isHave
when 0 then ....
when 1 then ....
end case;