code42 잔여처리

SELECT * FROM blur_process as bp LEFT JOIN pvr
ON pvr.pvrid = bp.pvrid
WHERE pvr.hidden = 0
GROUP BY bp.pvrid

SELECT * FROM pvr
WHERE pvrid LIKE '1201201%'

SELECT * FROM blur_process
WHERE pvrid LIKE '1201201%'

• 수정

mysql -u root -p
use gis_code42_0226;

 

SELECT * FROM 
(SELECT * from blur_process 
WHERE pvrid LIKE '1201101%')
as bp right JOIN pvr
ON pvr.pvrid = bp.pvrid
WHERE pvr.hidden = 0
AND bp.pvrid IS NULL
GROUP BY bp.pvrid;

SELECT * FROM 
(SELECT * from blur_process 
WHERE pvrid LIKE '1201201%')
as bp right JOIN pvr
ON pvr.pvrid = bp.pvrid
WHERE pvr.hidden = 0
AND bp.pvrid IS NULL
GROUP BY bp.pvrid;

SELECT * FROM 
(SELECT * from blur_process 
WHERE pvrid LIKE '1201301%')
as bp right JOIN pvr
ON pvr.pvrid = bp.pvrid
WHERE pvr.hidden = 0
AND bp.pvrid IS NULL
GROUP BY bp.pvrid;

SELECT * FROM 
(SELECT * from blur_process 
WHERE pvrid LIKE '1201401%')
as bp right JOIN pvr
ON pvr.pvrid = bp.pvrid
WHERE pvr.hidden = 0
AND bp.pvrid IS NULL
GROUP BY bp.pvrid;

SELECT * FROM blur_process as bp LEFT JOIN pvr
ON pvr.pvrid = bp.pvrid
WHERE pvr.hidden = 0
GROUP BY bp.pvrid

SELECT * FROM pvr
WHERE hidden = 0

MySQL Table의 데이터를 CSV 형태로 내보내기 방법에는 여러가지가 있습니다.어떤 방법으로만 해야된다가 아닌 상황에 맞게 사용하는게 좋을 거 같습니다.4 가지 예시입니다.

Instantly share code, notes, and snippets. MySQL Table의 데이터를 CSV 형태로 내보내기 방법에는 여러가지가 있습니다.어떤 방법으로만 해야된다가 아닌 상황에 맞게 사용하는게 좋을 거 같습니다.4 가지 예시입니다. You can't perform that action at this time. You signed in with another tab or window. You signed out in another tab or window.

https://gist.github.com/gaerae/6219678

ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

[MySQL] Load Data 시도 중 secure_file_priv 문제 직면

Load Data를 시도하던 중, The MySQL server is running with the --secure-file-priv option so it cannot execute this statement 문제에 직면하였다. mysql> SELECT @@GLOBAL.secure_file_priv; | @@GLOBAL.secure_file_priv | 1 row in set (0.00 sec) secure_file_priv에 특정 경로가 설정되어 있음을 확인할 수 있다. 경로가 설정되어 있다면 해당 경로에 있는 파일만 import 할 수 있다.

https://sssunho.tistory.com/56

• export 보안으로 그냥 안댐

Final

mysql -u root -p
use gis_code42_0226;

select a.pvrid
  FROM 
  (SELECT pvrid FROM pvr 
where hidden = 0 and pvrid LIKE '1201101%') as a
  LEFT OUTER JOIN blur_process as b
  ON a.pvrid = b.pvrid WHERE b.touch IS NULL
  into outfile 
'C:/Home/Projects/Software/Stryx/Delab/pj-checker/queries/blur-residue/0226/1.csv';
;