mysql 导出导入文件，txt

导出导入

 

SELECT `ID`,`USER_ID`,`RESUME_NAME`,`CREATE_TIME`,`COMPLETE_SCORE`,`ADVANTAGE`,`UPDATE_TIME`  FROM  `vt_resume`  INTO OUTFILE "/backup/table1_back_2018091016.txt"
    FIELDS TERMINATED BY '|'
    LINES TERMINATED BY '\n'
    
    
LOAD DATA LOCAL INFILE '/backup/table1_back_2018091016.txt' INTO TABLE `vt_resume_temp`
FIELDS TERMINATED BY '|'
LINES TERMINATED BY '\n';