Untitled query #40626

This query is marked as a draft This query has been published by Zhuyifei1999.

SQL

DELIMITER $$
CREATE PROCEDURE test ()
BEGIN

DECLARE finished INTEGER DEFAULT 0;
DECLARE wikiname varchar(100) DEFAULT "";

DEClARE cursite 
  CURSOR FOR 
    SELECT site_global_key FROM site;

DECLARE CONTINUE HANDLER 
  FOR NOT FOUND SET finished = 1;

OPEN cursite;

do_query: LOOP
  FETCH cursite INTO wikiname;
  IF finished = 1 THEN 
      LEAVE do_query;
  END IF;
  SELECT @wikiname;
END LOOP do_query;
CLOSE cursite;

END$$
DELIMITER ;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...