job pvr 데이터 차이

state priority state time - 400 50 0 current

통계 안맞는거도 이거때문?


SELECT a.pvrid
  from (SELECT pvrid from pvr) as a
  LEFT OUTER join job as b
  ON a.pvrid = b.pvrid
  where b.pvrid IS NULL

아니 숫자가 안맞음 ㅋㅋㅋ

망했다 후

이 안에서 또 들어간거 찾아봐야 할 듯


SELECT a.pvrid FROM (SELECT a.pvrid
  from (SELECT pvrid from pvr) as a
  LEFT OUTER join job as b
  ON a.pvrid = b.pvrid
  where b.pvrid IS NULL) AS a
, job AS b WHERE a.pvrid = b.pvrid

근데 겹치는게 왜 없지... 5개 나와야하는데

4개 겹치는 놈들이 범인 PRIORITY 30 어디서 나온거?

어쨌는 해결하고 이제 db 2000개 job 에 넣기


INSERT INTO job_100 (pvrid, state, priority, PROCESS, updatedatetimeus)
SELECT a.pvrid, 400, 0, 50, '2020.02.18 11:53:33.123456'
  from (select pvrid from pvr) as a
  LEFT OUTER JOIN job as b
  ON a.pvrid = b.pvrid
  WHERE b.pvrid IS null

test job 100

auto increment primary key 에 안되어있어서 해줌


INSERT INTO job (pvrid, state, priority, PROCESS, updatedatetimeus)
SELECT a.pvrid, 400, 0, 50, '2020.02.18 11:53:33.123456'
  from (select pvrid from pvr) as a
  LEFT OUTER JOIN job as b
  ON a.pvrid = b.pvrid
  WHERE b.pvrid IS null


INSERT INTO job (pvrid, state, priority, PROCESS, updatedatetimeus)
SELECT a.pvrid, 0, 50, 400, '2020.02.18 11:53:33.123456'
  from (select pvrid from pvr) as a
  LEFT OUTER JOIN job as b
  ON a.pvrid = b.pvrid
  WHERE b.pvrid IS null


SELECT pvrid FROM job
WHERE updatedatetimeus = '2020.02.18 11:53:33.123456'

왜 2623 아니라 2628이지는모그겠지만..


SELECT a.pvrid, 0, 50, 400, '2020.02.18 11:53:33.123456'
  from (select pvrid from pvr) as a
  LEFT OUTER JOIN job as b
  ON a.pvrid = b.pvrid
  WHERE b.pvrid IS null

없고