1 명령어[편집]wmic process get caption,creationdate | findstr 프로세스명 2 실행예시[편집]C:\Users\zetawiki>wmic process get caption,creationdate | findstr cmd.exe cmd.exe 20130118090908.793007+540 → cmd.exe 프로세스는 2013년 1월 18일 09:09에 시작되었다. 출처:https://zetawiki.com/wiki/%EC%9C%88%EB%8F%84%EC%9A%B0_%ED%94%84%EB%A1%9C%EC%84%B8%EC%8A%A4_%EC%8B%9C%EC%9E%91%EC%8B%9C%EA%B0%84_%ED%99%95%EC%9D%B8
SELECT * FROM original_table INTO OUTFILE 'original_table.csv' CHARACTER SET euckr FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n'; SELECT customer_id, firstname, surname INTO OUTFILE '/exportdata/customers.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM customers;
command ⌘ shift ⇧ option ⌥ control ⌃ caps lock ⇪ Preferences > Keymap > Max OS X 10.5+ 네비게이션 관련Declartion (클래스 및 메소드로 바로가기) : ⌘BPreference (설정): ⌘, Project structure (프로젝트 세팅) : ⌘;Type hiearachey (타입 계층 구조): ^HCall hiearachey (호출 계층 구조) : ^⌥HNavigate class (오픈 클래스) : ⌘ONavigate file (오픈 파일) : ⇧⌘OFile structure (Quick navagation, outline) : ⌘F12 Find Usage (해당 클래스 사용) : ⌥F7Switcher (탭간 이동) : ^Tab..
UPDATE tb_rising_item_kospi SET row_id = REPLACE(row_id, '20170101', '20170622') tb_rising_item_kospi 테이블의 row_id 컬럼에 있는 '20170101' 값을 '20170622'로 수정. WITH BASE AS ( SELECT '20170101' AS COLUMN1 FROM DUAL ) SELECT REPLACE(COLUMN1, '20170101', '20170102') AS REPLACE_COLUMN FROM BASE