mysql while loop Break equivalent

Question

What would be an equivalent of a break in a while loop for mysql?

  WHILE (ctr < i)
  DO ......

    SET cnt = (SELECT COUNT(*) FROM temp_results WHERE result = "true");
    IF cnt > 0 THEN
      SELECT cnt;
      BREAK;
    END IF;

Thanks

Tony O'Hagan · Accepted Answer · 2018-05-08 05:53:02Z

43

got it.

myloop: WHILE (ctr < i)
DO 
   …

   SET cnt = (SELECT COUNT(*) FROM temp_results WHERE result = "true");
   IF cnt > 0 THEN
      SELECT cnt;
      LEAVE myloop;
   END IF;
END WHILE myloop;

edited May 8, 2018 at 5:53

Tony O'Hagan

23k3 gold badges73 silver badges83 bronze badges

answered Nov 14, 2011 at 17:01

Shah

5,0388 gold badges27 silver badges33 bronze badges

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

1 Comment

Tony O'Hagan Over a year ago

I've updated this example. To use the LEAVE statement I found you required the myloop label repeated on the END WHILE statement.

Manjula · Accepted Answer · 2015-12-02 06:31:08Z

19

You might be interested in a REPEAT loop:

REPEAT  
    SET cnt = (SELECT COUNT(*) FROM temp_results WHERE result = "true");
UNTIL cnt > 0 
END REPEAT;

edited Dec 2, 2015 at 6:31

Manjula

5,1413 gold badges31 silver badges42 bronze badges

answered Nov 14, 2011 at 17:05

p.campbell

101k70 gold badges264 silver badges326 bronze badges

1 Comment

Mad Dog Tannen Over a year ago

This should be set as the correct way. Never even heard of the REPEAT, just tested it, flawless. Thanks @p.campbell

Collectives™ on Stack Overflow

mysql while loop Break equivalent

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

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

Linked

Related