CREATE DEFINER=`root`@`%` PROCEDURE `task_view_rebuild`()
BEGIN
DECLARE odr INT DEFAULT 1;
DECLARE idx INT DEFAULT 1;
DELETE FROM task_view;
WHILE ((SELECT COUNT(*) FROM task WHERE id=idx) > 0 AND (SELECT COUNT(*) FROM task_view) < 1000) DO
INSERT INTO task_view(odr, `id`,`next_id`,`name`,`target`,`request`,`reward`,`limit_time`,`reset`,`fail_reward`,`guide`,`auto_finish`,`show`)
(SELECT odr, `id`,`next_id`,`name`,`target`,`request`,`reward`,`limit_time`,`reset`,`fail_reward`,`guide`,`auto_finish`,`show`
FROM task
WHERE id = idx);
SET odr = odr + 1;
SET idx = (SELECT next_id FROM task WHERE id = idx);
END WHILE;
END
mysql函数(task_view)
最新推荐文章于 2024-09-24 09:50:23 发布