mysql简单的触发器语法_mysql触发器语法及实例

mysql触发器：

1.语法：

create trigger trigger_name trigger_time  trigger_event on table_name for each row trigger_stmt

trigger_time:是触发动作时间，可以是before或者after

trigger_event:是触发语句类型，可以是insert ,update,delete

trigger_stmt:是触发之后需要做什么，如果是多个语句需要用begin  end

2.实例

示例一

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 ;