问题描述
我正在使用以下更新语句来更新我的数据库表中的一行
I'm using following update statement to update a row in a table of my database
update department
set budget = budget + 0.01
where dept_name = 'Physics';
但是，运行此代码会出现以下错误:
However, running this code gives the following error:
ERROR 1305 (42000): PROCEDURE university.update_budget_proc does not exist
我无法从该错误消息中做出任何判断.我附上了我在终端输入命令时的截图.
I'm not able to make anything out of this error message. I have attached the screenshot of when I type the commands in terminal.
另外，提到我从未创建过错误消息中提到的任何过程update_budget_proc".它真的与更新声明有关吗?
Also, to mention that I have never created any procedure 'update_budget_proc' which is mentioned in the error message. Does it really have anything to do with the update statement ?
推荐答案
上面评论中的猜测结果证明是正确的.
The guess in the comments above turned out to be right.
UPDATE 正在执行一个触发器，而该触发器又引用了一个不再存在的存储过程.
The UPDATE was executing a trigger, which in turn had a reference to a stored procedure that no longer exists.
这篇关于执行 Mariadb 更新语句时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！