http://stackoverflow.com/questions/4862911/how-to-throw-an-error-in-mysql-procedure
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:
the job command is:
then:
My jobq. BTW I am using MySQL 5.5.8 thanks Arman. | |||||||||
|
Yes, there is: use the | |||||
|
![](http://engine.adzerk.net/i.gif?e=eyJhdiI6NDgxLCJhdCI6NCwiYnQiOjAsImNtIjo0ODYxMDUsImNoIjoxMTc4LCJjayI6e30sImNyIjoxNjgxNTczLCJkaSI6ImU1ZjllNmZmMGQyMTQ2Zjk5YjVhZDcyYThiNzhhMDNlIiwiZG0iOjEsImZjIjoxOTk3NzI3LCJmbCI6MjMzMTU3MiwiaXAiOiI3My45Ny4yMjYuMTExIiwia3ciOiJteXNxbCxzdG9yZWQtcHJvY2VkdXJlcyx0aHJvdyxzdG9yZWQtZnVuY3Rpb25zIiwibnciOjIyLCJwYyI6My4zNSwiZWMiOjMuMzUsInByIjo3NjUsInJ0IjoyLCJyZiI6Imh0dHBzOi8vd3d3Lmdvb2dsZS5jb20vIiwic3QiOjgyNzcsInVrIjoidWUxLTVjMjc0YjQ0NWIzMjQ3MzRhYjIyY2UwODM0NmNjOWU3Iiwiem4iOjQ0LCJ0cyI6MTQ3NDI2NDczMzA0NCwiYmYiOnRydWUsInBuIjoiYWR6ZXJrNDYxNDcxNTgzIiwiZnEiOjB9&s=qVFAtE2EE3KsyVHHSSfXpeKsKaw)