DB2数据库教程

时间:2020-10-12 10:40:11
【文件属性】:

文件名称:DB2数据库教程

文件大小:12.31MB

文件格式:PDF

更新时间:2020-10-12 10:40:11

DB2

启动DB2服务:db2start 关闭DB2服务: db2stop 一、加载数据: 1、 以默认分隔符加载,默认为“,”号 db2 "import from btpoper.txt of del insert into btpoper" 2、 以指定分隔符“|”加载 db2 "import from btpoper.txt of del modified by coldel| insert into btpoper" import from import.txt of del modified by coldel | insert into ts_tcqs_rhjgb import from import.txt of del modified by coldel: insert into ts_tcqs_rhjgb 二、卸载数据: 1、 卸载一个表中全部数据 db2 "export to btpoper.txt of del select * from btpoper" db2 "export to btpoper.txt of del modified by coldel| select * from btpoper" export to export2.txt of del modified by coldel: select * from ts_tcqs_xtztb


网友评论