db2导出数据到txt文档,以及将txt数据导入到数据库中

export to c:ceshi/student.txt of del modified by CODEpage=1386 chardel'' coldel0x03 

select id,name,age from student where age > 18;

 

import from c:ceshi/student.txt of del modified by DELPRIORITYCHAR codepage=1386 chardel '' coldel0x03 compound=100 commitcount 500 

insert into student

(

id,name,age

);

posted @ 2020-01-03 14:17  xixihaha_jxt  阅读(1685)  评论(0编辑  收藏  举报