错误代码：1305 MySQL，函数不存在
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/16077946/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Error Code: 1305 MySQL, Function does not Exist
提问by randytan
I have a problem. I created a function in MySQL which returns a String (varchar data type).
我有个问题。我在 MySQL 中创建了一个函数，它返回一个字符串（varchar 数据类型）。
Here's the syntax:
这是语法：
DELIMITER $$
USE `inv_sbmanis`$$
DROP FUNCTION IF EXISTS `SafetyStockChecker`$$
CREATE DEFINER=`root`@`localhost` FUNCTION `SafetyStockChecker`
(jumlah INT, safetystock INT)
RETURNS VARCHAR(10) CHARSET latin1
BEGIN
DECLARE statbarang VARCHAR(10);
IF jumlah > safetystock THEN SET statbarang = "Stabil";
ELSEIF jumlah = safetystock THEN SET statbarang = "Perhatian";
ELSE SET statbarang = "Kritis";
END IF;
RETURN (statbarang);
END$$
DELIMITER ;
When I call the function like call SafetyStockChecker(16,16), I get this error:
当我调用函数时call SafetyStockChecker(16,16)，我收到此错误：
Query : call SafetyStockChecker(16,16)
Error Code : 1305
PROCEDURE inv_sbmanis.SafetyStockChecker does not exist
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000
查询：调用 SafetyStockChecker(16,16)
错误代码：1305
PROCEDURE inv_sbmanis.SafetyStockChecker 不存在
执行时间：00:00:00:000
传输时间：00:00:00:000
总时间：00:00:00:000000
What's wrong with the function?
函数有什么问题？
回答by John Woo
That is not the correct way to call a function. Here's an example to call a function:
这不是调用函数的正确方法。这是调用函数的示例：
SELECT SafetyStockChecker(16,16) FROM TableName
The way you are doing now is for calling a STORED PROCEDURE. That is why the error says:
您现在的做法是调用 a STORED PROCEDURE。这就是为什么错误说：
PROCEDURE inv_sbmanis.SafetyStockChecker does not exist
PROCEDURE inv_sbmanis.SafetyStockChecker 不存在
because it is searching for a Stored procedure and not a function.
因为它正在搜索存储过程而不是函数。
回答by Amit Garg
You should use
你应该使用
SELECT SafetyStockChecker(16,16)
