DB2 导入导出数据

软件用例：Quest Central for DB2 

---

 

导出文件

---

取前10条  保存在C盘

Export to c:\consumer2.csv of del select mobile,name,birth, gender from csm_consumer  fetch first 10 rows only;

注：.csv 后缀也可该改成.txt 等

 

导入文件

---

import from c:\consumer2.csv of del insert into csm_consumer;

执行报错了 > 查原因

 

结果：导入的话若没有和表字段名称匹配则失败

 

 

参考文章：

https://henry-cong.iteye.com/blog/1133554

https://zhidao.baidu.com/question/77747935.html

https://zhidao.baidu.com/question/646432233018865445.html

https://blog.csdn.net/ring1303/article/details/79607504

https://blog.csdn.net/lc893572812/article/details/49506697