Mysql uses small notes such as stored procedures and events [Mark] And mysqlmark

Mysql uses small notes such as stored procedures and events [Mark] And mysqlmark

Bytes ------------------------------------------------------------------------------------------------
[Create a stored procedure and use variables and random numbers]

DELIMITER $

Drop procedure if exists 'Week _ luck_call '$
Create procedure week_luck_call ()
Begin
DECLARE var_rankluck int default 99999; -- must be placed in the first row
Delete from rankluck;
Set var_rankluck = ROUND (RAND (), 5) * 100000 );
Insert into rankluck ('guid ', 'luck') select 'guid ', var_rankluck from ranklist order by value desc limit 100;
End $

DELIMITER;

Bytes ------------------------------------------------------------------------------------------------
[Create a mysql event, event trigger time, period, and so on]

Delimiter $

Create procedure week_luck_call ()
Begin
Delete from rankluck;
Insert into rankluck ('guid ', 'luck') select 'guid ', 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 '2017-12-17 08:00:00 'on completion preserve do call week_luck_call ();

Drop event week_luck;