Shulou(Shulou.com)05/31 Report--

This article shares with you the content of sample analysis of MySQL cursors and exception handling. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Complex exception handling

Drop procedure if exists t2

Delimiter $$

Create procedure T2 ()

Begin

Declare done int default 0

Declare vResult int default 0

Declare vUserID bigint

Declare vBalance int

Declare pChecksum varchar (32)

Declare cur_test CURSOR for select * from user

DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1

Open cur_test

Repeat

Fetch cur_test into vUserID, vBalance,pChecksum

If done! = 1 then

Set vResult:=vResult+vBalance

End if

Until done end repeat

Close cur_test

Select vResult

End$$

Delimiter

Call T2 ()

Thank you for reading! This is the end of this article on "sample analysis of MySQL cursors and exception handling". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.