我写了一个很简答的触发器,但创建时,提示我
insert into history(name,content)values('name','content');这行有错误,但我把这条insert语句单拿出来执行也没问题。提示错误是: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 'insert into history(name,content)values('name','content')' at line 3CREATE TRIGGER t_wz_u_trigger_bu BEFORE UPDATE ON manuscript FOR EACH ROW
BEGIN
insert into history(name,content)values('name','content');
END;
insert into history(name,content)values('name','content');这行有错误,但我把这条insert语句单拿出来执行也没问题。提示错误是: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 'insert into history(name,content)values('name','content')' at line 3CREATE TRIGGER t_wz_u_trigger_bu BEFORE UPDATE ON manuscript FOR EACH ROW
BEGIN
insert into history(name,content)values('name','content');
END;
解决方案 »
- 【求救】mysql导入备份文件,mysql server has gone away的问题
- mysql存储过程参数可不可以带默认值
- powerbulder怎么和mysql连
- 我想买套windows下的mysql,不知道要多少钱,哪里有?
- mysql中mysql_stmt_fetch返回值MYSQL_DATA_TRUNCATED的问题
- 使用set global 某个变量,是mysql 重启就无效了吗
- 谁能改我说一下mysql运行信息中哪几个比较关键!(我的mysql速度超慢,我想研究研究是怎么回事情)
- 关于mySQL中的SELECT语句的一些困扰,请赐教!
- MySQL创建表错误
- 关于数据库名称是中文的问题
- 要做一个大型的购物网站 怎么设计数据库啊
- 刚开始试用MySql,问个问题
BEGIN
insert into history set name = 'name';
END--try
BEGIN
insert into "history" set name = 'name';
END
--try
`id` int(11) NOT NULL auto_increment,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;CREATE TABLE `history` (
`name` varchar(30) NOT NULL default '',
`content` varchar(30) default '',
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;CREATE TRIGGER t_wz_u_trigger_bu BEFORE UPDATE ON asd
FOR EACH ROW BEGIN
insert into history(name,content)values('name','content');
END;insert into asd VALUES(default);
update asd set id=11 where id=1;一切正常.
delimiter ||
CREATE TRIGGER t_wz_u_trigger_bu BEFORE UPDATE ON manuscript FOR EACH ROW
BEGIN
insert into history(`name`,content)values('name','content');
END||
delimiter ;