mysql触发器出现错误

[underlemontree]

create trigger memuser
after insert on sj_members
for each row
begin
insert into hy_members set

username=new.username,password=new.password;
end;

这个在MYSQL数据库中执行老是出现错误，版本是5.1的。出现以下错误：
MySQL 返回：

#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 '' at line 7

[wwwwb]

delimiter $$
create trigger memuser
after insert on sj_members
for each row
begin
insert into hy_members values(new.username,new.password);
end;$$
delimiter ;

[underlemontree]

谢谢，请出个完整的吧，
我是个新手，
$$ 这是个什么意思

[wwwwb]

修改语句结束符

[underlemontree]

我执行了下面的程序：
delimiter
create trigger memuser
after insert on sj_members
for each row
begin
insert into hy_members (username,password) values(new.username,new.password);
end;
delimiter ;
又出现下面的错误：

错误
SQL 查询:

CREATE trigger memuser AFTER INSERT ON sj_members
FOR each
ROW
BEGIN
INSERT INTO hy_members( username,
PASSWORD )
VALUES (

new.username, new.password
);

END ;

delimiter;



MySQL 返回：

#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 'delimiter' at line 7

[wwwwb]

delimiter $$

[ACMAIN_CHM]

先用

delimiter $$
CREATE trigger memuser AFTER INSERT ON sj_members
FOR each
ROW
BEGIN
INSERT INTO hy_members( username,
PASSWORD )
VALUES (

new.username, new.password
);

END $$

delimiter;

[EC王]

额，这个有点让我疑惑的说。

[zuoxingyu]

delimiter;

这个命令的作用，你百度一下。