名人自动刷新命令名人自动刷新命令
/*?ÇÂ???ÅÅÐеÚÒ?ÃûµÄ*/
INSERT INTO audition.1jiangli SET big=(select UserSN from itemdb.board_item_info where price =500 group by UserSN order by count(UserSN) desc limit 1),small=(select UserSN from
itemdb.board_item_info where price =30 group by ...
名人自动刷新命令
/*?ÇÂ???ÅÅÐеÚÒ?ÃûµÄ*/
INSERT INTO audition.1jiangli SET big=(select UserSN from itemdb.board_item_info where price =500 group by UserSN order by count(UserSN) desc limit 1),small=(select UserSN from
itemdb.board_item_info where price =30 group by UserSN order by count(UserSN) desc limit 1), notice=(select usersn from gonggao.rank order by shumu desc limit 1), notice2=(select usersn from gonggao.notice_rank order by shumu desc limit 1),chongzhi=(select usersn from audition.rudolf_mark_log where consumer ='?ý?Ö' group by usersn order by SUM(RMPoint) desc limit 1),chongzhi2=(select usersn from gonggao.meili order by shumu desc limit 1);
/*???????æµÚÒ?µÄÔùËÍ10000???æ*/
update audition.rudolf_mark_jifen set JiFen =JiFen+50000 where UserSN =(select usersn from gonggao.notice_rank order by shumu desc limit 1);
/*?ÊÉ????æµÚÒ?µÄÔùËÍ8000*/
update audition2.rudolf_mark_info set JiFen =JiFen+3000 where UserSN =(select usersn from gonggao.rank order by shumu desc limit 1);
/*?óÀ??ȵÚÒ?µÄÔùËÍ2WMB*/
update itemdb.usercash set Cash =Cash+200000 where UserSN =(select UserSN from itemdb.board_item_info where price =500 group by UserSN order by count(UserSN) desc limit 1);
/*Ð?À??ȵÚÒ?µÄÔùËÍ1ÍòMB*/
update itemdb.usercash set Cash =Cash+80000 where UserSN =(select UserSN from itemdb.board_item_info where price =30 group by UserSN order by count(UserSN) desc limit 1);
/*?åÖµ?ý?ÖµÚÒ?µÄÔùËÍ1W?ý?Ö*/
update audition.rudolf_mark_jifen set JiFen =JiFen+10000 where UserSN =(select usersn from audition.rudolf_mark_log where consumer ='?ý?Ö' group by usersn order by SUM(RMPoint) desc limit 1);
/*?ÈÁ?µÚÒ?µÄÔùËÍ8000?ý?Ö*/
update audition.rudolf_mark_jifen set JiFen =JiFen+15000 where UserSN =(select usersn from gonggao.meili order by shumu desc limit 1);
/*ÇåÀí???????æÊý?Ý*/
delete from gonggao.notice_rank;
/*ÇåÀí?ÊÉ????æÊý?Ý*/
delete from gonggao.rank;
/*ÇåÀíÀ??ÈÊý?Ý*/
delete from itemdb.board_item_info;
/*ÇåÀí?äÖµÊý?Ý*/
delete from audition.rudolf_mark_log;
/*ÇåÀí???????æÊý?Ý*/
delete from gonggao.shiyongjilu;
/*ÇåÀí?ÊÉ????æÊý?Ý*/
delete from gonggao.shiyongjilu_1;
/*ÇåÀí?ÈÁ?Êý?Ý*/
delete from gonggao.meili;
delete from gonggao.meili_jilu;
本文档为【名人自动刷新命令】，请使用软件OFFICE或WPS软件打开。作品中的文字与图均可以修改和编辑，
图片更改请在作品中右键图片并更换，文字修改请直接点击文字进行修改，也可以新增和删除文档中的内容。
该文档来自用户分享，如有侵权行为请发邮件ishare@vip.sina.com联系网站客服，我们会及时删除。
[版权声明] 本站所有资料为用户分享产生，若发现您的权利被侵害，请联系客服邮件isharekefu@iask.cn，我们尽快处理。
本作品所展示的图片、画像、字体、音乐的版权可能需版权方额外授权，请谨慎使用。
网站提供的党政主题相关内容(国旗、国徽、党徽..)目的在于配合国家政策宣传，仅限个人学习分享使用，禁止用于任何广告和商用目的。
浙公网安备 33021202002483