C#
2015.10.03 00:53
MySQL to CSV && csv to mysql
조회 수 149084 추천 수 0 댓글 3
SELECT id, itemcode, wdate, market, high, low, finish FROM stock_market_price
INTO OUTFILE './my.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
LOAD DATA INFILE '/home/wings/my2.csv' INTO TABLE stock_data FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';
or
LOAD DATA LOCAL INFILE './my.csv' INTO TABLE stock_data FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' (itemcode, wdate, open, high, low, close);
- ?
-
?
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';
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);