mysql添加trigger

create trigger au_bbs_user
before insert on bbs_user
for each row
begin
insert into users(name,pwd) values(new.user_name,new.pwd);
end;

create trigger bu_bbs_user
before update on bbs_user
for each row
begin
update users set pwd=new.pwd where name=new.user_name;
end;