mysql throw_[数据库]How to throw an error in MySql procedure?

最新推荐文章于 2021-03-17 20:14:30 发布

鲸商

最新推荐文章于 2021-03-17 20:14:30 发布

阅读量90

点赞数

文章标签： mysql throw

本文链接：https://blog.csdn.net/weixin_28936865/article/details/113911124

版权

What is the mechanism to force the MySQL to throw an error within the stored procedure?

I have a procedure which call s another function:PREPARE my_cmd FROM @jobcommand;EXECUTE my_cmd;DEALLOCATE PREPARE my_cmd;

the job command is:jobq.exec("Select 1;wfdlk# to simulatte an error");

then:CREATE PROCEDURE jobq.`exec`(jobID VARCHAR(128),cmd TEXT)BEGINDECLARE result INT DEFAULT 0; SELECT sys_exec( CONCAT('echo ',cmd,' | base64 -d > ', '/tmp/jobq.',jobID,'.sh ; bash /tmp/jobq.',jobID,'.sh &> /tmp/jobq.',jobID)) INTO result; IF result>0 THEN # call raise_mysql_error(result); END IF;END;

My jobq.exec is always succeeding. Are there way to rise an error? How to implement raise_mysql_error function??

BTW I am using MySQL 5.5.8

thanks Arman.

mysql stored-procedures throw stored-functions

shareimprove this questionasked Feb 1 '11 at 13:06

Arman1,89652952