[mysql]throw exception

CREATE PROCEDURE pro_throwException (errorCode char(5), errorMessage text)

BEGIN

SIGNAL SQLSTATE errorCode SET MESSAGE_TEXT = errorMessage;

END

posted @ 2016-05-12 14:06  陈意  阅读(385)  评论(0)  编辑  收藏  举报