![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_224,w_224)
数据库
mysql,mongodb
Beyond_奈何
奈何落花有意随流水,流水无心恋落花。
展开
-
mysql变量查询实现计数排行
先看mysql一个简单的变量查询:SET @rowNum = 0; SELECT ( @rowNum := @rowNum + 1 ) AS rankNum;变量初始值rowNum设置为0,查询一行数据变量+1,定义为排行号,也是数据行号用途一:数据排行现在签到表结构如下:CREATE TABLE `sign_in` ( `phone` varchar(11) NOT NULL COMMENT '登录手机号', `integral_num` decimal(3,0) NOT原创 2020-10-31 12:49:33 · 732 阅读 · 0 评论 -
项目中SET @rowNum = 0和SELECT语句一起执行
还拿上篇中sql举例:SET @rowNum = 0;SELECT ( @rowNum := @rowNum + 1 ) AS rowNo, t.phone, t.count FROM ( SELECT phone, count( 1 ) AS count FROM sign_in GROUP BY phone ORDER BY count DESC LIMIT 10 ) t;方法一:合并成一条语句SELECT ( @rowNum := @rowNum + 1 ) AS r原创 2020-10-31 12:50:56 · 1981 阅读 · 0 评论