MySQL小技巧 - 从数据库读取当前数据处在总记录的进度

最新推荐文章于 2024-07-21 19:06:05 发布

u014709673

最新推荐文章于 2024-07-21 19:06:05 发布

阅读量92

点赞数

文章标签： mysql javascript

本文链接：https://blog.csdn.net/u014709673/article/details/131586591

版权

从数据库读取当前数据处在总记录的进度，js代码

/**
 * 获取单个sql语句
 * @param  {[str]}  s_kcrwdm        [编号]
 * @param  {[str]}  id        [唯一id]
 * @return {[str]} [sql语句]
 * @desc 该语句执行MySQL返回的数组类似 {p:56} 0-100之间，包括100
 */
function getASql(s_kcrwdm,id){
    return 'SELECT (ROUND(rowsnumber*100/(SELECT COUNT(*) as d FROM `schedule_list` WHERE `s_kcrwdm`="'+s_kcrwdm+'"))) as p FROM (SELECT `id`, @rownum := @rownum +1 AS rowsnumber'+
        '  FROM schedule_list,(SELECT@rownum :=0) r '+
        '  WHERE `s_kcrwdm`="'+s_kcrwdm+'"'+
        ' order by `date` asc,`s_jcdm` asc'+
        ') t '+
        'WHERE t.id="'+id+'"';
}

MySQL语句

//四舍五入取整 注意两个数据 s_kcrwdm和id
SELECT (ROUND(rowsnumber*100/(SELECT COUNT(*) as d FROM `schedule_list` WHERE `s_kcrwdm`="202240028230"))) as p FROM (SELECT `id`, @rownum := @rownum +1 AS rowsnumber
  FROM schedule_list,(SELECT@rownum :=0) r 
  WHERE `s_kcrwdm`="202240028230"
 order by `date` asc,`s_jcdm` asc
) t 
WHERE t.id='542'