final blur data management

hidden 인 애들 그냥 넣어서 폐기 늘어나고 있었음..


SELECT w.workerid, w.name, count(bp.pvrid)
FROM (
  SELECT pvrid, touch, worker_id, date, date_updated
  FROM blur_process
  where touch in (20,30)
) AS bp
LEFT JOIN (
  SELECT pvrid, hidden
  FROM pvr
) AS p
ON bp.pvrid=p.pvrid
left join view3 AS w on bp.worker_id = w.workerid
where year(bp.date) =  '2020'
and month(bp.date) = '02'
and day(bp.date) = '23'
AND ( p.hidden != 0 OR p.hidden IS NULL )
group by w.workerid
order by w.workerid;


delete blur_residue.* FROM blur_residue left join
pvr
ON blur_residue.pvrid=pvr.pvrid
WHERE pvr.hidden != 0;

왼쪽 코드가 불러오는 코든데 hidden 된 애들이 블러되고 있다는 말

오른쪽 코드로 수정해줌.. 내실수

SQL Essencial column 이 있어서 primary auto increment 로 추가

auto increment 하면 자동등록 되는군

column 명 조같이 지어서 `` 로 접근해야함


SELECT pvrid, `PRIMARY` from
(SELECT a.*, COUNT(*) AS count FROM blur_residue AS a
LEFT JOIN blur_residue AS b
ON a.pvrid = b.pvrid GROUP BY a.pvrid) AS c
WHERE COUNT = 4

SQL standard to escape column names?

Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question. Provide details and share your research! Asking for help, clarification, or responding to other answers. Making statements based on opinion; back them up with references or personal experience. To learn more, see our tips on writing great answers.

https://stackoverflow.com/questions/2901453/sql-standard-to-escape-column-names

다른거 남아있는지 확인

그냥 select 한거를 선택해서 지우기

실제로


SELECT * FROM blur_process
WHERE worker_id = 'sriver1'

GetWorkList.php 로 호출하면 바로 10 touch로 들어간다 이걸로 지움 ㅎㅎ 죄송

final blur data management

Recommendations