执行 Mariadb 更新语句时出错

Error while executing Mariadb update statement(执行 Mariadb 更新语句时出错)

问题描述

我正在使用以下更新语句来更新我的数据库表中的一行

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 更新语句时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！