MySQL to CSV && csv to mysql

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);

참고: http://moonlighting.tistory.com/140