首页 > 数据库技术 > 详细

mysql 使用存储过程,事件等的一些小笔记 [Mark]

时间:2014-12-19 14:11:42      阅读:248      评论:0      收藏:0      [点我收藏+]

------------------------------------------------------------------------------------------------
[创建存储过程,使用变量,随机数字]

DELIMITER $$

DROP PROCEDURE IF EXISTS `week_luck_call` $$
CREATE PROCEDURE week_luck_call()
begin
DECLARE var_rankluck INT DEFAULT 99999; -- 必须放在第一行
delete from rankluck;
set var_rankluck = ROUND(ROUND(RAND(),5)*100000);
insert into rankluck (`guid`, `luck`) select `guid`, var_rankluck from ranklist order by value desc limit 100;
end $$

DELIMITER ;

------------------------------------------------------------------------------------------------
[创建mysql事件,事件触发时间、周期等]

delimiter $$

create procedure week_luck_call()
begin
delete from rankluck;
insert into rankluck (`guid`, `luck`) select `guid`, ROUND(ROUND(RAND(),5)*100000) from ranklist order by value desc limit 100;
end $$

delimiter ;

drop procedure week_luck_call;

create event week_luck on schedule every 1 week starts ‘2014-12-17 08:00:00‘ on completion preserve do call week_luck_call();

drop event week_luck;

mysql 使用存储过程,事件等的一些小笔记 [Mark]

原文:http://www.cnblogs.com/xjon/p/4173656.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!