存储过程的书写

DELIMITER $$

DROP PROCEDURE IF EXISTS `ipqam_test`$$
CREATE
    PROCEDURE `global_fujian`.`ipqam_test`()
    BEGIN
        DECLARE v_landmark VARCHAR(255); --定义变量
    declare done tinyint(1) default 0;  
    DECLARE curJob CURSOR FOR (select landmark from landmark_relation limit 1); --将查询结果赋值给游标
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE; -- 监听器  

    OPEN curJob; -- 打开游标  
    label:LOOP  

        FETCH curJob INTO v_landmark;  --将游标的值付给变量
        IF done THEN LEAVE label;
        END IF;  
        select * from ipqam where landmark = v_landmark;
    END LOOP label;  
    CLOSE curJob; -- 关闭游标  
    END$$

DELIMITER ;