[MySQL/Hackerrank] Print Prime Numbers

Print Prime Numbers

SET @i = 2;
SET @isPrime = 0;
SET @result = '';

DELIMITER $$ 
CREATE PROCEDURE PrintPrime(IN num INT)
BEGIN 
    WHILE @i < num DO
        SET @j = @i - 1;
        SET @isPrime = 1;    
        
        WHILE @j > 1 DO
            IF @i % @j = 0 THEN 
                SET @isPrime = 0;
            END IF;
            SET @j = @j - 1;
        END WHILE;
        
        IF @isPrime = 1 THEN 
            SET @result = CONCAT(@result, @i, '&');
        END IF;                
        
        SET @i = @i + 1;   
    END WHILE ;   
    
    SET @result = SUBSTR(@result, 1, LENGTH(@result) - 1);    
    SELECT @result;    
END$$ 
DELIMITER ;

CALL PrintPrime(1000);