Breaking News: Grepper is joining You.com. Read the official announcement!

mysql loop

ApolloGab Delmundo answered on June 27, 2022 Popularity 10/10 Helpfulness 3/10

answer mysql loop

mysql loop

Comment

mysql loop

CREATE PROCEDURE LoopDemo()
BEGIN
	DECLARE x  INT;
	DECLARE str  VARCHAR(255);
        
	SET x = 1;
	SET str =  '';
        
	loop_label:  LOOP
		IF  x > 10 THEN 
			LEAVE  loop_label;
		END  IF;
            
		SET  x = x + 1;
		IF  (x mod 2) THEN
			ITERATE  loop_label;
		ELSE
			SET  str = CONCAT(str,x,',');
		END  IF;
	END LOOP;
	SELECT str;
END$$

Popularity 10/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: mysql sql

Link to this answer
Share Copy Link

Contributed on Jun 27 2022

ApolloGab Delmundo

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

mysql loop

Contents

More Related Answers

mysql loop

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.