Infra/DataBase23 [SQL] 생성 개수 확인 minus select * from ( select distinct product_id A, product_id as seq from product_inf A where A.PRODUCT_GUBUN='L' minus select distinct product_id as A, SUBSTR(B.brd_seq,2, 13) as seq from product_inf A, brd_list1_set B where SUBSTR(B.brd_seq,0,1) = 'L' and A.product_id = SUBSTR(B.brd_seq,2, 13) 2009. 10. 9. [SQL] 다중업데이트 UPDATE PRODUCT_INF a SET ( a.apply_dt, a.conf_dt) = (SELECT CREATIONDATE, CREATIONDATE FROM KTCMASTER01T b WHERE a.product_id= b.clubid ) WHERE EXISTS (SELECT 'x' FROM KTCMASTER01T b WHERE a.product_id= b.clubid AND b.USEYN='Y' ) 2009. 10. 9. DataBase 커낵션코드 ## MySql "jdbc:mysql://localhost:3306/project?useUnicode=true&characterEncoding=KSC5601"; 2009. 10. 9. 이전 1 ··· 3 4 5 6 다음