
复制示例一 delimiter // create trigger InsertUser before insert on user for each row Begin insert into user_group(uid,发器
gid) values(new.uid,group4444444444); end;// delimiter ; 示例二 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 ; 示例三: delimiter // create trigger InsertUser before insert on user for each row Begin IF new.type=1 then insert into user_group(uid,gid) values(new.uid,578d3369633b47bd9c1fe8bf905cbfb1); END IF; IF new.type=2 then insert into user_group(uid,gid) values(new.uid,387bcd57fc5a4c3c9de83ee210fef661); END IF; end;// delimiter ; 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.
作者:应用开发