mysql function 错误_如何在MySQL函数中引发错误

它实际上是所有三个答案的组合。您调用一个不存在的过程来引发该错误，然后声明一个退出处理程序来捕获您生成的错误。这是一个示例，如果要删除的行设置了外键ID，则使用SQLSTATE 42000(过程不存在)在删除前引发错误：

DROP PROCEDURE IF EXISTS decount_test;

DELIMITER //

CREATE DEFINER = 'root'@'localhost' PROCEDURE decount_test ( p_id bigint )

DETERMINISTIC MODIFIES SQL DATA

BEGIN

DECLARE EXIT HANDLER FOR SQLSTATE '42000'

SELECT 'Invoiced barcodes may not have accounting removed.';

IF (SELECT invoice_id

FROM accounted_barcodes

WHERE id = p_id

) THEN

CALL raise_error;

END IF;

DELETE FROM accounted_barcodes WHERE id = p_id;

END //

DELIMITER ;

输出：

call decount_test(123456);

+----------------------------------------------------+

| Invoiced barcodes may not have accounting removed. |

+----------------------------------------------------+

| Invoiced barcodes may not have accounting removed. |

+----------------------------------------------------+