<code> 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 ;</code>
现在参数orders不起作用，麻烦懂的人帮忙修改下，谢谢哈。
回复内容：
<code> 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<p style="color:transparent">。本文来源gao!%daima.com搞$代*!码网1</p><cite>搞代gaodaima码</cite> 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 ;</code>
现在参数orders不起作用，麻烦懂的人帮忙修改下，谢谢哈。
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：MySQL 存储过程，参数无效，求解
转载请注明原文链接：MySQL 存储过程，参数无效，求解
