php - MySQL 存储过程,参数无效,求解
PHPz
PHPz 2017-04-10 14:26:44
0
2
600
    DROP PROCEDURE IF EXISTS market.app_get_list;
    DELIMITER //

    CREATE PROCEDURE market.app_get_list(IN orders VARCHAR(20), IN type TINYINT, IN offset INT, IN rows INT)
    BEGIN
        DECLARE done INT DEFAULT 0;
        DECLARE pack VARCHAR(40);
        DECLARE packages CURSOR FOR SELECT DISTINCT package FROM market_app ORDER BY orders DESC LIMIT offset, rows;
        DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1; 

    OPEN packages;

    REPEAT
        FETCH packages INTO pack;
        IF NOT done THEN
            SELECT * FROM market_app WHERE package = pack ORDER BY versioncode DESC LIMIT 1;
        END IF;
    UNTIL done END REPEAT;

    CLOSE packages;
END//

    DELIMITER ;

现在参数orders不起作用,麻烦懂的人帮忙修改下,谢谢哈。

PHPz
PHPz

学习是最好的投资!

reply all(2)
phpcn_u38476

php - MySQL stored procedure, invalid parameter, solution


phpcn_u38476

php - MySQL stored procedure, invalid parameter, solution


Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!