在mysql中创建第一个触发器_在mysql中创建触发器出错，高人解

CREATETRIGGERinsert_members_triggerBEFOREINSERTonuc_membersFOREACHROWBEGINset@myid:=NEW.uid;set@name:=NEW.username;set@pwd:=NEW.password;set@email:=NEW.password;set@regip...

CREATE TRIGGER insert_members_trigger BEFORE INSERT on uc_members

FOR EACH ROW BEGIN

set @myid:=NEW.uid;

set @name:=NEW.username;

set @pwd:=NEW.password;

set @email:=NEW.password;

set @regip:=NEW.regip;

set @regdate:=NEW.regdate;

insert into cdb_members (uid,username,password,groupid,regip,regdate,email,pmsound,showemail,newsletter,timeoffset) values (@myid,@name,@pwd,10,@regip,@regdate,@email,1,1,1,9999);

insert into coc_enewsmember (userid,username,password,email,registertime,groupid,checked) values (@myid,@name,@pwd,email,@regdate,1,1);

end;

这是错误

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'set @myid:=NEW.uid' at line 3

还有一条

CREATE TRIGGER usertype_update AFTER UPDATE on uchome_spacefield

FOR EACH ROW

BEGIN

update uchome_space set usertype = new.field_1 where uid = old.uid;

end;

这是错误

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'update uchome_space set usertype = new.field_1 where uid = old.uid' at line 4

我用的是phpmyadmin

展开