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不起作用,麻烦懂的人帮忙修改下,谢谢哈。
安装、修复、更新或打包一个基于 Python 和 PyMySQL 实现的 Windows `mysql` 命令。适用于用户希望在 PowerShell/CMD 中输入 `mysql` 时重定向到 Python 实现、需要交互式输入 MySQL 连接信息、需要同步到当前用户本地 bin 目录,或需要将该能力封装成可公开复用的 Codex skill。
回复内容:
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不起作用,麻烦懂的人帮忙修改下,谢谢哈。










