MySQL可以非常方便的导入导出平面文件。
测试如下.
导出为平面文件
平面文件如下:
1,"u1"
2,"u2"
3,"u3"
导入平面文件
FIELDS TERMINATED BY ',' 字段间分割符
OPTIONALLY ENCLOSED BY '"' 将字段包围 对数值型无效
LINES TERMINATED BY '\n' 换行符
测试如下.
导出为平面文件
- 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' 换行符
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29254281/viewspace-1183701/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
