편집 기록

오라클에서 mysql로 변환중입니다...

select
  days.mdate ,
  ifnull(login_cnt,0) as login_cnt ,
  ifnull(logout_cnt,0) as logout_cnt
  from ( select '2016-06-16' as mdate from ts_user where limit 1,1 ) days
  left join ( select substr(vl_date,0,10) as mdate ,
  sum(case when vl_login_yn = 'Y' then 1 else 0 end) login_cnt ,
  sum(case when vl_login_yn != 'Y' then 1 else 0 end) logout_cnt
  from
   ts_visit_log
   where substr(vl_date,0,10)
    between ? and ? 
    group by substr(vl_date,0,10) ) log
    on log.mdate = days.mdate
    order by days.mdate asc

대체 이게 무슨말인가요?

오라클에서 mysql로 변환중입니다...ㅜㅜㅜㅜ

select days.mdate , ifnull(login_cnt,0) as login_cnt , ifnull(logout_cnt,0) as logout_cnt from ( select '2016-06-16' as mdate from ts_user where limit 1,1 ) days left join ( select substr(vl_date,0,10) as mdate , sum(case when vl_login_yn = 'Y' then 1 else 0 end) login_cnt , sum(case when vl_login_yn != 'Y' then 1 else 0 end) logout_cnt from ts_visit_log where substr(vl_date,0,10) between ? and ? group by substr(vl_date,0,10) ) log on log.mdate = days.mdate order by days.mdate asc