执行Mariadb更新语句时出错 [英] Error while executing Mariadb update statement

问题描述

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

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'.它确实与update语句有关吗?

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