DROP TRIGGER TRIGGER1;
CREATE TRIGGER TRIGGER1 AFTER INSERT ON course
FOR EACH ROW
BEGIN
UPDATE course SET name='""'+name WHERE credit=2;
END;
INSERT INTO course VALUE(4,'sql',2)报错误 1442
[SQL]INSERT INTO course VALUE(4,'sql',2)
[Err] 1442 - Can't update table 'course' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.
CREATE TRIGGER TRIGGER1 AFTER INSERT ON course
FOR EACH ROW
BEGIN
UPDATE course SET name='""'+name WHERE credit=2;
END;
INSERT INTO course VALUE(4,'sql',2)报错误 1442
[SQL]INSERT INTO course VALUE(4,'sql',2)
[Err] 1442 - Can't update table 'course' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.
解决方案 »
- mysql 触发器 对本表的操作,真的不清楚错哪里了~~求大牛~~
- mysql4.0.16中的sql-bin-update-same参数是什么意思呢?
- mysql如何导入导出大量数据
- C++ 调用 mysql 中的问题
- mysql在创建存储过程是一直提示的一个语法问题
- 请问SQL和MYSQL有什么区别呢?学哪个难点,学哪个吃香点呢?谢谢回答啊
- 如何修改mysql配置以及连接件,连接代码才能使字符编码全部使用utf-8?
- libmysql动态链接库
- mysql 双重游标问题
- 生成编号的函数返回了重复的值(手动commit验证时,发MySQL表中出现了两条编号数据。commit后又消失了)
- 项目连接MySQL数据库,提示异常
- MySQL数据库新手对复制数据的疑问
触发器的限制,如果是处理触发的行,可以直接设置 NEW 的值
SET NEW.name='""'+NEW.name