本节内容:
mysql触发器实例
例1,
复制代码 代码示例:
delimiter //
create trigger InsertUser
before insert on user
for each row
Begin
insert into user_group(uid,gid) values(new.uid,'group4444444444');
end;//
delimiter ;
例2,
复制代码 代码示例:
delimiter //
create trigger InsertUser
before insert on user
for each row
Begin
IF new.Type=2 then
insert into user_group(uid,gid) values(new.uid,'group4444444444');
else
insert into user_group(uid,gid) values(new.uid,'group55555555555')
END IF;
end;//
delimiter ;
例3,
复制代码 代码示例:
delimiter //
create trigger InsertUser
before insert on user
for each row
Begin
IF new.type=1 then
insert