100 degrees TM is similar to this:
declare done int default false;
declare mycursor cursor for select * from ;
declare continue HANDLER for not found set done = true;
-- , not found , done true.
but this time it brings a pit, because an ordinary select query, if not found, will also trigger the not found
event, thus changing the value of the tag variable .
excuse me, doesn"t MySQL have a better strategy? If so, stored procedures are really hard to use!