티스토리 뷰
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;
'Database' 카테고리의 다른 글
ORACLE ROWID를 이용한 중복데이터 삭제 (0) | 2020.12.17 |
---|---|
MySQL 전체 테이블 대상 삭제, 생성, SELECT-INSERT, 권한 관련 쿼리 (0) | 2017.09.18 |
MySQL Dump& Import (0) | 2017.09.18 |
컬럼의 특정 문자열 치환 (0) | 2017.06.23 |
CONNECT BY LEVEL을 이용한 날짜 조회 (0) | 2017.04.21 |
댓글