Shulou(Shulou.com)06/01 Report--

User lottery module

Award_gift_record is the user raffle record table.

Among them, actiontime is the lucky draw time.

AwardGiftID said that the winning gift ID.-1 means that he did not win the lottery.

AwardactId represents the active ID

Demand: query the number of lotteries per minute and the number of winners

Create table nums (id int not null primary key)

Delimiter $$

Create procedure pCreateNums (cnt int)

Begin

Declare s int default 1

Truncate table nums

While s

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.