执行报错,麻烦大神们看一下什么问题,感谢 select t1.dt, round(count(distinct t2.uid)/count(t1.uid), 2) uv_left_rate from -- 新用户首次登录日期表 (select uid, min(date(in_time)) dt from tb_user_log group by uid) as t1 left join ( select uid, date(in_time) dt from tb_user_log union -- 去重合并获得用户活跃表 select uid, dete(out_time) dt from tb_user_log ) as t2 on t1.uid=t2.uid and t1.dt=date_sub(t2.dt, interval 1 day) where date_format(t1.dt,'%Y-%m') = '2021-11' group by t1.dt order by t1.dt; 程序异常退出, 请检查代码"是否有数组越界等异常"或者"是否有语法错误" SQL_ERROR_INFO: "execute command denied to user 'root'@'localhost' for routine 'dete'"
点赞

相关推荐

牛客网
牛客网在线编程
牛客网题解
牛客企业服务