2015년 11월 23일 월요일

Mysql table to csv import, export

When exporting mysql table to csv file

@csv export

select *
into outfile
'/tmp/tableBackUp.csv'
FIELDS TERMINATED BY ','
from test_data_table;

When importing exported csv to mysql table

@csv import

LOAD DATA INFILE 'xxx.csv'
IGNORE INTO TABLE test_table
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n';

댓글 없음 :

댓글 쓰기