# 网上用mysql(5.5版本)定时调用存储的教程……可以说要不就哆唆……写一大堆(手册!),要不就不完美,连用Delimiter 改个 delimiter 的“结束符号”都懒得写全(或者根本就不会写),俺写个相对完整,又不LuoSuo的吧!
# s2是您的数据库的名字……
show variables like '%sche%';
set global event_scheduler=1;
drop procedure if exists test;
delimiter //
CREATE PROCEDURE test ()
BEGIN
update s2.shuipf_article set views=FLOOR(0+(RAND()* 3))+views where views<93;
select * from shuipf_article order by views limit 0,10;
END;
//
drop event if exists e_test;
//
delimiter //
CREATE EVENT if not exists e_test
on schedule every 100 second
on completion preserve
do call test();
//
alter event e_test ON COMPLETION PRESERVE ENABLE;
//
delimiter ;