Getting Success or Failure Detection in Stored Procedure

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

I have a stored procedure that has a simple insert statement.  I want to
be able to tell if the insert statement executed successfully, and
return using a tinyint whether the statement was successful or not.  My
googling efforts did not result in anything useful, probably because I
do not know the proper terminology.  I am using mysql-5.0.18-nt.  So,
the question is, what syntax is used to trap a result code from an
insert query, and what specific code is for success, assuming that any
other code is a failure.  At this point I don't need to know what the
failure is, though at some point I might start logging these.


Site Timeline