SELECT itemcode, itemname, DNA_Score, DNA_Index, probability, MAX_rate, MIN_rate FROM DNA_rank
INTO OUTFILE './DNA_rank.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';

SELECT wdate, itemcode, itemname, DNA_Score, DNA_Index, probability, MAX_rate, MIN_rate FROM time_series_1Y
INTO OUTFILE './1Y.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';

SELECT wdate, itemcode, itemname, DNA_Score, DNA_Index, probability, MAX_rate, MIN_rate FROM time_series_2Y
INTO OUTFILE './2Y.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';

============

LOAD DATA INFILE './DNA_rank.csv' INTO TABLE DNA_rank FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'
(itemcode, itemname, DNA_Score, DNA_Index, probability, MAX_rate, MIN_rate);

LOAD DATA INFILE './1Y.csv' INTO TABLE time_series_1Y FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'
(itemcode, itemname, DNA_Score, DNA_Index, probability, MAX_rate, MIN_rate);

LOAD DATA INFILE './2Y.csv' INTO TABLE time_series_2Y FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'
(itemcode, itemname, DNA_Score, DNA_Index, probability, MAX_rate, MIN_rate);

LOAD DATA LOCAL INFILE '/usr/local/mariadb/data/RATB.csv'
INTO TABLE ETF.RATB_itemcode
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(itemcode, itemname, type);

옵션 1분봉 데이터를 CSV로 출력(2012 ~ 2017: 2017년 자료는 서버오류로 데이터가 거의 없음)

SELECT wdate, wtime, start, high, low, final, quantity, price, month, itemCode
FROM Chart_Option
ORDER BY itemCode ASC, wdate ASC, wtime ASC
INTO OUTFILE './Chart_Option.csv'
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n';