informix数据库unload导出数据&&Load导入数据
进入数据库
执行命令 dbaccess test - -
例如:
导出全部数据
unload to /opt/informix/abc.csv delimiter "," select * from test;
导出前十行数据
unload to /home/informix/ces.csv delimiter "," select first 10 * from ttq;
/home/informix 为指定吐出数据文件csv 路径。
导入数据
Load from ces.csv delimiter "," insert into ttt;
其中的delimiter是用来定义分隔符的,分隔符默认是"| " 但是也可以写为" ,"