本文共 401 字，大约阅读时间需要 1 分钟。

1、建立存储过程

BEGIN	#Routine body goes here...declare ids INT;declare stop int default 0;declare cur cursor for( SELECT id FROM test s WHERE cid = 125 AND statu=1);declare CONTINUE HANDLER FOR SQLSTATE '02000' SET stop = null;OPEN cur; FETCH cur INTO  ids;  WHILE ( stop is not null) DO		UPDATE test set votes = votes + FLOOR(5+RAND()*5) where id=ids;		FETCH cur INTO  ids;	END WHILE;CLOSE cur;END

2、建立定时事件

转载地址：https://blog.csdn.net/Carson073/article/details/84983943 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！