如何在 MySQL 函数中引发错误

2021-11-20 00:00:00 function exception mysql stored-procedures

我创建了一个 MySQL 函数，如果为参数传递的值无效，我想引发错误.在 MySQL 函数中引发错误的选项有哪些?

I've created a MySQL function and would like to raise an error if the values passed for the parameters are invalid. What are my options for raising an error within a MySQL function?

推荐答案

MySQL 5.5 引入了信号，类似于其他语言中的异常:

MySQL 5.5 introduces signals, which are similar to exceptions in other languages:

http://dev.mysql.com/doc/refman/5.5/en/signal.html

例如在mysql命令行客户端:

mysql> SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Custom error'; ERROR 1644 (45000): Custom error

相关文章