mysql exit handler help

Question

I have a simple update that will use a transaction. If the transaction fails, I want to rollback and send out an integer value of 0. Here is my code so far. It isn't working and all I get back is integer 1 even when it fails.

declare exit handler for not found rollback;
declare exit handler for sqlwarning rollback;
declare exit handler for sqlexception rollback;
set row = 0;

START TRANSACTION;
UPDATE user
SET name = name
WHERE code = code;
COMMIT;

set row = 1;

Does anyone have any ideas how I can fix this? Really, I'm open here. If someone has a better approach, I'm all ears.

sra · Accepted Answer · 2012-01-02 11:12:33Z

3

You can enclose the commands with BEGIN and END:

  DECLARE EXIT HANDLER FOR SQLEXCEPTION,NOT FOUND,SQLWARNING
    BEGIN
      ROLLBACK;
      SELECT 0;
    END;

edited Jan 2, 2012 at 11:12

sra

24k8 gold badges59 silver badges89 bronze badges

answered Aug 18, 2010 at 20:07

ChoNuff

8226 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ChoNuff Over a year ago

Sorry, the formatting didn't go through. The "BEGIN" is on a separate line, as is "rollback;", "select 0;" and "end;".

soulmerge · Accepted Answer · 2010-02-05 14:57:22Z

0

I don't know if you just posted the wrong code, but your query is not generating any errors, you are overwriting x with x where y equals y, which is a NOP.

answered Feb 5, 2010 at 14:57

soulmerge

76.3k20 gold badges121 silver badges160 bronze badges

1 Comment

James1012 Over a year ago

Thanks for the answer soulmerge. This is the code that I am using. Funny thing.. I am using this same code for an insert and it works perfect. I have looked over this code and compared it against the working code and there is no difference. I'm stumped.

Collectives™ on Stack Overflow

mysql exit handler help

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related