sina-video/updateRank.sql

/**
  清除排名中奖旧数据
 */
DELETE FROM `awards_order` where `type` = 2;


/**
  插入排名中奖数据
 */
INSERT INTO `awards_order` (`uid`, `rank`, `gift_id`, `type`)
VALUES
(7331841275,1,1,2),
(7312220225,2,2,2),
(5482542453,3,2,2),
(5748693260,4,2,2),
(5315483631,5,2,2),
(5997609128,6,2,2),
(7290034423,7,2,2),
(7489453887,8,2,2),
(7415584948,9,2,2),
(7339328286,10,2,2),
(7464895722,11,2,2),
(5658990124,12,2,2),
(6875044323,13,2,2),
(7097905055,14,2,2),
(7415831414,15,2,2),
(7239588166,16,2,2),
(5958366188,17,2,2),
(6010782013,18,2,2),
(6598247984,19,2,2),
(7313444351,20,2,2),
(5633153495,21,2,2),
(2286803047,22,3,2),
(7318797027,23,3,2),
(7356918008,24,3,2),
(7475149404,25,3,2),
(7340921714,26,3,2),
(5744850460,27,3,2),
(6858477359,28,3,2),
(7554779923,29,3,2),
(7488338078,30,3,2),
(7596786506,31,3,2),
(7755185060,32,3,2),
(7757399795,33,3,2),
(7375001827,34,3,2),
(7326050091,35,3,2),
(7670433967,36,3,2),
(5130640517,37,3,2),
(5828405802,38,3,2),
(6834665781,39,3,2),
(7027494474,40,3,2),
(7385200551,41,3,2),
(6475365595,42,3,2),
(7340925502,43,3,2),
(7416155809,44,3,2),
(5969206432,45,3,2),
(7292625182,46,3,2),
(7729775165,47,3,2),
(7514560063,48,3,2),
(7690280141,49,3,2),
(7744805791,50,3,2)