How to catch and re-throw all errors in MySQL

Question

I can't seem to find anywhere how to catch and re-throw any errors or warnings that can occur in a procedure.

What I want is the syntax to do the following:

create procedure myProcedure()
  begin

      declare exit handler for ANYTHING_WRONG_THAT_CAN_BE_CAUGHT_WARNINGS_INCLUDED
      begin
          rollback;
          RE_THROW THE_THING_THAT_WAS_CAUGHT;
      end;

      start transaction;
         -- do some stuff
      commit;
  end; //

The reason being that I want to force a rollback on an error or warning but leave it up to the client to decide what to do with the specific error.

The all-cap areas are the portions where I do not know what to put.

Thanks for any help!

Edit -------

I have since learned it is not possible to do what I have asked :'(.

Instead I have a single error for anything that goes wrong and used the following code:

declare exit handler for sqlwarning, sqlexception begin
    rollback;
    call error();
end;

(error() does not exist)

Answer 1

To catch all SQL exceptions, use:

DECLARE EXIT HANDLER FOR SQLEXCEPTION

SQLWARNINGS can be used to catch warnings also.

Inside the exception handler, to raise the error or warning that was just caught, use:

RESIGNAL

See the documentation for the RESIGNAL statement:

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

This is available since MySQL 5.5