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
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
解决方案 »
- mysql数据查询
- 2003服务器 重启红 mysql 启动超级慢!要2个小时左右!
- 启动postgresql时遇到post_create这个错误.请教高手.在线守侯.
- 问个MYSQL的基础问题,排序字段时否需要建索引
- 关于 mysql 的 1067 的错误
- DECLARE continue handler for not found是什么意思 非要在过程中出现吗
- 远程访问linux下面的mysql极其缓慢
- 我的MYSQL自从安装好以后从别的机器就连不上,但是再本机上就可以,另外用telnet登陆也可以连上,请高手进来看看。
- 用JDBC连接MySQL的怪问题
- mysql.select语句里怎样批量的在一个字段前面加指定字符?也就是update语句怎样写才能实现?
- mysql 函数丢失如何恢复
- 如何比较两个数据库中的表和记录的不同?版本比较
create trigger memuser
after insert on sj_members
for each row
begin
insert into hy_members values(new.username,new.password);
end;$$
delimiter ;
我执行了下面的程序:
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
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;