mysql 觸發器insert

delimiter //create trigger InsertUserbefore insert on userfor each rowBegin    insert into user_group(uid,gid) values(new.uid,'group4444444444');end;//delimiter ;樣本二delimiter //create trigger InsertUserbefore insert on userfor each rowBegin　　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 InsertUserbefore insert on userfor each rowBeginIF 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 ;