1.MYSQL表导出成数据文件
select * from AGENT into outfile 'e://ss_load_data//AGENT.txt' fields terminated by '%';
2.数据文件导入DB2数据库
import from /home/schedule/zhanglg/txt/AGENT.txt of del modified by coldel% timestampformat="YYYY-MM-DD HH:MM:SS" delprioritychar replace into 底部DB2INFO.AGENT;
mySql To DB2
最新推荐文章于 2022-11-18 17:08:20 发布