MySQL导入导出平面文件

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"

导入平面文件

1. 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' 换行符 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29254281/viewspace-1183701/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29254281/viewspace-1183701/