MySQL可以非常方便的匯入匯出平面檔案。

測試如下.

匯出為平面檔案

select * from t1 into outfile 'F:/backup.sql' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';

    平面檔案如下:
    1,"u1"
    2,"u2"
    3,"u3"

匯入平面檔案

LOAD DATA INFILE 'F:/backup.sql' INTO TABLE mvbox.t1 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';

    FIELDS TERMINATED BY ',' 欄位間分割符
    OPTIONALLY ENCLOSED BY '"' 將欄位包圍對數值型無效
    LINES TERMINATED BY '\n' 換行符

MySQL匯入匯出平面檔案

相關文章