56,677
社区成员
发帖
与我相关
我的任务
分享
DELIMITER $$
DROP PROCEDURE IF EXISTS `database`.`top_create_level` $$
CREATE PROCEDURE `database`.`top_create_level` ()
BEGIN
DECLARE nRankOrder INT;
SET @nRankOrder := 1;
# clear current table
TRUNCATE TABLE database.top_level;
INSERT database.top_level
SELECT t0.ID, t0.Level, t0.Name, @nRankOrder := @nRankOrder + 1
FROM database.account AS t0
ORDER BY t0.Level Desc Limit 5000;
END $$
DELIMITER ;
DELIMITER $$
DROP PROCEDURE IF EXISTS `database`.`top_create_level` $$
CREATE PROCEDURE `database`.`top_create_level` ()
BEGIN
DECLARE nRankOrder INT;
SET nRankOrder = 1;
# clear current table
TRUNCATE TABLE database.top_level;
INSERT database.top_level
SELECT t0.ID, t0.Level, t0.Name, nRankOrder = nRankOrder + 1
FROM database.account AS t0
ORDER BY t0.Level Desc Limit 5000;
END $$
DELIMITER ;