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';
댓글 없음 :
댓글 쓰기